## Covid-19 and Jharkhand Analysis
## Author: Carlos F. Gould
## Date: July 31, 2020
## Purpose: Review data collected

# 0. Libraries ----

library(tidyverse)
library(readxl)
library(openxlsx)
library(lubridate)
library(haven)
library(arsenal)
library(cowplot)
library(ggstatsplot)
library(ggsci)

mycontrols  <- tableby.control(test=TRUE, total=FALSE,
                               numeric.stats=c("N", "meansd", "medianq1q3", "range", "Nmiss"),
                               cat.stats=c("countpct", "Nmiss"),
                               stats.labels=list(N='Count', meansd='Mean (SD)', medianq1q3='Median (IQR)'),
                               digits = 2L,
                               digits.pct = 0L)


# 1. Read Data ----

# baseline data
jbaseline <- read_dta("~/Dropbox/Jharkhand-COVID19/Data/jharkhand_access_data.dta")

# covid survey data
jcovid1 <- read_xlsx("~/Dropbox/Jharkhand Energy Access Project/1st Follow up/Shared Data/Jharkhand Energy Access Lockdown_Follow-up Shared Data_Without Identification_26th August.xlsx")[-1,] %>%
  filter(`participate _Would you like to participate?`==1)

jcovid2 <- read_xlsx("~/Dropbox/Jharkhand Energy Access Project/2nd Follow up/Shared Data/Jharkhand Energy Lockdown 2nd Round_Shared Data_23rd October.xlsx")[-1,] %>% 
  filter(`participate _Would you like to participate?`==1)

jcovid3 <- read_xlsx("~/Dropbox/Jharkhand Energy Access Project/3rd Follow up/Shared Data/Jharkhand Energy Access Lockdown 3rd followup Shared Data_26th December.xlsx")[-1,] %>% 
  filter(`participate _Would you like to participate?`==1)

jcovid4 <- read_xlsx("~/Dropbox/Jharkhand Energy Access Project/4th Follow up/Shared Data/Jharkhand Lockdown 4th round Shared data_De-identified_23rd April.xlsx")[-1,] %>% 
  filter(`participate _Would you like to participate?`==1)

jcovid5 <- read_xlsx("~/Dropbox/Jharkhand Energy Access Project/5th Follow up/Shared Data/Jharkhand Lockdown 5th round_Main Data_De-identified_9th June.xlsx")[-1,] %>% 
  filter(`participate _Would you like to participate?`==1)

jcovid6 <- read_xlsx("~/Dropbox/Jharkhand Energy Access Project/6th Follow up/Shared Data/Jharkhand Lockdown 6th round Main survey_De-identified_5th July.xlsx")[-1,] %>% 
  filter(`participate _Would you like to participate?`==1)

# Combined, full data
jcovid_full_b_1 <- read_csv("~/Dropbox/Jharkhand-COVID19/Data/jcovid_full_b_1.csv")

# 2. Rename columns -----

# Round 1 -------
jcovid1_1 <- jcovid1 %>%
  rename(hhid = `hh_id_ Household ID_Baseline IDs`,
         age = `age_What is your age? _________ [years]`,
         age1 = `age_1_What is your age? _________ [years]`,
         date_interview = `date_int_Date of Interview`,
         start_time_interview = `start`,
         end_time_interview = `end`,
         
         b_1_relation_to_hhead = `q_b_1  What is your relationship to the household head?`,
         b_2_is_primary_cook = `q_b_2  Are you the primary cook for the household?`,
         b_3_gender = `q_b_3  What is your gender?`,
         
         c_1_1_econ_hardship_difficulty_food = `c_1_1  In the past 7 days, has your family endured any of the following economic hardships due to COVID-19? [ASK ALL QUESTIONS]_Increased difficulty accessing food for the household\r\n`,
         c_1_2_econ_hardship_increase_prices = `c_1_2  Increased prices for necessary goods`,
         c_1_3_econ_hardship_reduced_income = `c_1_3 Reduced income from any form of economic activity`,
         c_1_4_econ_hardship_salary_employment_loss = `c_1_4  Loss of salaried employment`,
         c_1_5_econ_hardship_hourly_employment_loss = `c_1_5  Loss of hourly waged employment, or loss of daily waged employment`,
         c_1_6_econ_hardship_hourly_employment_reduced = `c_1_6  Reduced hours of employment, or reduced days of waged employment`,
         # c_1_7_econ_hardship_other_cash_sources_reduced = c_1_7, # not present in the first round of surveys
         # c_1_8_econ_hardship_unable_tolook_employment = c_1_8, # not present in the first round of surveys
         
         c_2_hh_size_change = `c_2  Since the beginning of the coronavirus outbreak, has there been a change in the number of people sleeping in your household?`,
         # c_2_1_hhsize_more_workerreturned_pandemic = `c_2_1_1_Somebody working elsewhere returned home because of the coronavirus outbreak`,
         # c_2_2_hhsize_more_workerreturned_planned = `c_2_1_2_Somebody working elsewhere returned home, as was already planned`,
         # c_2_3_hhsize_more_studentreturned_pandemic = `c_2_1_3_Somebody studying elsewhere returned home because of the coronavirus outbreak`,
         # c_2_4_hhsize_more_studentreturned_planned = `c_2_1_4_ Somebody studying elsewhere returned home, as was already planned`,
         # c_2_5_hhsize_more_other = `c_2_1_other specify`,
         # c_2_1_hhsize_less_workerleft_pandemic = `c_2_2_1_Somebody that was living at home left to go work elsewhere, due to the coronavirus pandemic`,
         # c_2_2_hhsize_less_workerleft_planned = `c_2_2_2_Somebody that was living at home left to go work elsewhere, as was already planned`,
         # c_2_3_hhsize_less_studentleft_pandemic = `c_2_2_3_ Somebody that was living at home left to go study elsewhere, due to the coronavirus pandemic`,
         # c_2_4_hhsize_less_studentleft_planned = `c_2_2_4_Somebody that was living at home left to go study elsewhere, as was already planned`,
         # c_2_5_hhsize_less_other = `c_2_2_other specify`,
         
         c_3_lockdown_ago_weeks = `c_3 How long ago did your block experience orders to restrict time outdoors due to covid-19? _____ [weeks]`,
         c_4_change_lockdown_since = `c_4  Has there been a change in orders to restrict time outdoors in your area since then?`,
         
         d_0_1_primary_lighting_fourdays = `d_0_1  In the last four days, what has been the primary source of lighting in your household?`,
         d_0_1_primary_lighting_other = `d_0_1_other specify`,
         
         d_0_all_lighting_grid = `d_0_1   Grid electricity`,
         d_0_all_lighting_kerosene = `d_0_2  Kerosene lamp/lantern`,
         d_0_all_lighting_microgrid = `d_0_3  Micro-grid`,
         d_0_all_lighting_solar = `d_0_4   Solar home system or solar lantern`,
         d_0_all_lighting_other = `d_0_other specify`,
         
         d_0_2_has_kerosene = `d_0_2  Does your household have kerosene lamps for lighting?`,
         d_0_2_1_1_not_used_kerosene_nofuel = `d_0_2_1_1  No kerosene fuel in the household`,
         d_0_2_1_2_not_used_kerosene_conservingfuel = `d_0_2_1_2  Running low on kerosene fuel in the household and saving it`,
         d_0_2_1_3_not_used_kerosene_unablebuy = `d_0_2_1_3   Unable to purchase kerosene from ration shop or usual place of purchase`,
         d_0_2_1_4_not_used_kerosene_notgoodlight = `d_0_2_1_4  Kerosene is not a good source of light`,
         d_0_2_1_5_not_used_kerosene_unsafe = `d_0_2_1_5  Kerosene is not safe`,
         d_0_2_1_6_not_used_kerosene_hasbetter = `d_0_2_1_6  No need because we have better forms of lighting`,
         d_0_2_1_7_not_used_kerosene_broken = `d_0_2_1_7   Kerosene lamps are broken`,
         d_0_2_1_8_not_used_kerosene_other = `d_0_2_1_other specify`,
         
         d_0_3_1_kerosene_use_compare = `d_0_3_1  Thinking back to before the lockdown, are you now using kerosene for lighting more, the same, or less than before? [Note to surveyor: Do not read options unless clarification needed]`,
         d_0_3_2_kerosene_use_compare_hours = `d_0_3_2  Thinking back to during the lockdown, in comparison to before lockdown, did you use kerosene for lighting for the same number of hours, for more hours, or for fewer hours? [do not read options unless clarification needed]`,
         d_0_3_4_kerosene_use_hours = `d_0_3_4  n the last four days, in a typical day, how many hours a day did you have at least one kerosene lamp on for lighting? [NUMBER OF HOURS DURING WHICH AT LEAST ONE LAMP IS ON] ______________ [HOURS/DAY]`,
         
         d_2_primary_cook_fuel = `d_2  In the last four days, what has been your primary cooking fuel?`,
         d_2_primary_cook_fuel_other = `d_2_other specify`,
         
         d_1_1_firewood = `d_1_1  Firewood and chips`,
         d_1_2_any_cook_fuel_agresidue = `d_1_2  Agricultural or crop residue`,
         d_1_3_any_cook_fuel_dung = `d_1_3  Animal waste / dung cakes`,
         d_1_4_any_cook_fuel_charcoal = `d_1_4  Charcoal`,
         d_1_5_any_cook_fuel_coal = `d_1_5  Coal`,
         d_1_6_any_cook_fuel_kerosene = `d_1_6  Kerosene / paraffin`,
         d_1_7_any_cook_fuel_alcohol = `d_1_7   Alcohol / ethanol`,
         d_1_8_any_cook_fuel_gasoline = `d_1_8  Gasoline / diesel (not in generator)`,
         d_1_9_any_cook_fuel_lpg = `d_1_9  Liquefied petroleum gas (LPG)`,
         d_1_10_any_cook_fuel_biogas = `d_1_10  Bio-gas`,
         d_1_11_any_cook_fuel_electricity = `d_1_11   Electricity`,
         d_1_12_any_cook_fuel_other = `d_1_other specify`,
         
         d_3_has_lpg = `d_3  Does your household have an LPG connection?`,
         d_3_1_1_not_used_lpg_nofuel =`d_3_1_1  No LPG fuel in the household`,
         d_3_1_2_not_used_lpg_conservingfuel =`d_3_1_2  Running low on LPG fuel in the household and saving it`,
         d_3_1_3_not_used_lpg_notcookusualdishes =`d_3_1_3  The households has not cooked the usual dishes that the LPG stove is used for`,
         d_3_1_4_not_used_lpg_otherfuels =`d_3_1_4  The household has lots of other fuels that we are using instead`,
         d_3_1_5_not_used_lpg_notlikenow =`d_3_1_5   We do not like to use the LPG stove these days`,
         d_3_1_6_not_used_lpg_fearful =`d_3_1_6  Fear of using the LPG stove`,
         d_3_1_7_not_used_lpg_usualcookisnotcook =`d_3_1_7   The person that normally cooks using LPG has not been cooking`,
         d_3_1_8_not_used_lpg_broken = `d_3_1_8  The LPG stove is broken and cannot be used`,
         d_3_1_9_not_used_lpg_other = `d_3_1_other specify`,
         
         d_4_lpg_via_pmuy = `d_4  Did you receive the LPG connection under Pradhan Mantri Ujjwala Yojana (PMUY)?`,
         d_5_multiple_cylinders = `d_5  Do you have more than one gas cylinder in your household?`,
         d_5_1_multiple_cylinders_sizes = `d_5_1  What size are the LPG cylinders you currently have?`,
         d_5_2_one_cylinder_size = `d_5_2_What size is the LPG cylinder you currently have?`,
         d_5_3_singleordouble_connection = `d_5_3_Do you have a single or double bottle connection from your LPG provider (LPG Agency)?`,
         d_5_4_second_cylinder_source = `d_5_4_If single bottle connection, so from whom did you take the second LPG cylinder?`,
         
         d_6_fourdays_typical_number_meals = `d_6  In the last four days, during a typical day, about how many meals have been cooked in your house? (Note to interviewer: this question seeks to estimate the average number of meals cooked per day -- not a sum over the past four days) _________ [# meals per day]`,
         d_7_fourdays_hours_cook = `d_7  In the last four days, during a typical day, how much time is spent cooking? _________ [# hours per day]All meals combined — total number of hours cooking / stove on in the entire day`,
         d_8_1_cook_hours_compare_inlockdown = `d_8_1  Thinking back to before the lockdown, are you now cooking in total for more hours, for the same number of hours, or for fewer hours as compared to before?`,
         d_8_2_cook_hours_compare_recalllockdown = `d_8_2  During the lockdown, in comparison with before the lockdown, did you cook for more hours, for the same number of hours, or for fewer hours overall? [do not read options unless clarification needed]`,
         
         d_9_lpg_use_compare = `d_9  Compared to before lockdown, how are you using LPG? If something has changed, please tell us. [READ OPTIONS]`,
         d_10_pollutingfuel_use_compare = `d_10  Thinking back to before the lockdown, how would you describe your use of the traditional fuels like firewood, coal, dung, agricultural residues, and kerosene now? [READ OPTIONS]`,
         
         e_1_1_refill_lpg_inlockdown = `e_1_1  Since the lockdown began, have you refilled your LPG cylinder?`,
         e_1_2_refill_lpg_recalllockdown = `e_1_2 During the period of the lockdown, did you refill your LPG cylinder?`,
         
         e_2_refill_lpg_wksago = `e_2  How many weeks ago did you last refill your large LPG cylinder? ______ [# weeks]`,
         e_3_refill_source = `e_3  Where did you get that refill from?`,
         e_3_refill_source_other = `e_3_other specify`,
         e_4_1_refill_differences_nodelivery = `e_4_1 No delivery as compared to usual delivery`,
         e_4_2_refill_differences_deliverynow = `e_4_2  Delivery as compared to not usually getting delivery`,
         e_4_3_refill_differences_longerwait = `e_4_3   Longer wait as compared to usual at distributor shop`,
         e_4_4_refill_differences_shorterwait = `e_4_4  Shorter wait as compared to usual at distributor shop`,
         e_4_5_refill_differences_pickupfurther = `e_4_5  Village pick-up point was further away than usual`,
         e_4_6_refill_differences_pickupcloser = `e_4_6  Village pick-up point was closer than usual`,
         e_4_7_refill_differences_none = `e_4_7_There were no differences`,
         e_4_8_refill_differences_other = `e_4_other specify`,
         
         e_5_subsidy_time_compare = `e_5  Thinking back to before the lockdown, does it take less time, more time, or the same amount of time to receive the subsidy amount in your bank account?`,
         e_6_lpgrefill_cost = `e_6  How much did you pay at the time of purchase for your last LPG cylinder? ______ [INR]`,
         e_7_1_nolpg_refill_didnotrunout = `e_7_1  Did not run out of gas`,
         e_7_2_nolpg_refill_rationed = `e_7_2  Rationed gas so I did not run out`,
         e_7_3_nolpg_refill_nomoney = `e_7_3   Did not have money available`,
         e_7_4_nolpg_refill_didnotwanttoleave = `e_7_4  Did not want to leave household to get refill`,
         e_7_5_nolpg_refill_deliveryunavailable = `e_7_5  Normal gas delivery not available`,
         e_7_6_nolpg_refill_couldnotleave = `e_7_6 Was not allowed to leave household to get refill`,
         e_7_7_nolpg_refill_other = `e_7_other specify`,
         
         e_8_refill_next_wks = `e_8  When do you expect to next refill an LPG cylinder? ______ [# weeks]`,
         
         f_1_firewood_compare_collect_freq_inlockdown = `f_1 As compared to before the lockdown, has your household been collecting firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_2_firewood_compare_collect_amt_inlockdown = `f_2 As compared to before the lockdown, has your household collected more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         # f_3_firewood_compare_reserve_amt_inlockdown = `f_3 As compared to before the lockdown, does the household now have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically? [Note for surveyor: This question refers to the amount/volume/weight of fuel being stored in the household. Households often have some amount of fuel being stored that they then are able to use for cooking at any given point. Here, we ask if they have approximately the same, more, or less fuel stored in the household as compared to before.]`,
         f_4_firewood_compare_collect_difficulty_inlockdown = `f_4  As compared to before the lockdown, does the household now have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_5_firewood_compare_collect_freq_recalllockdown = `f_5  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_6_firewood_compare_collect_amt_recalllockdown = `f_6  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         f_7_firewood_compare_reserve_amt_recalllockdown = `f_7  Thinking back to during the lockdown, in comparison with before the lockdown, did your household have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically?`,
         f_8_firewood_compare_collect_amt_recalllockdown = `f_8  Thinking back to during the lockdown, as compared to non-lockdown times, did your household have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_9_firewood_collect_last_days = `f_9  When was the last time a household member collected firewood, twigs, agricultural residues, or dung cakes? ______ [days ago]`,
         f_10_firewood_collect_next_days = `f_10  When do you expect that a household member will next go for collecting firewood, twigs, agricultural residues, or dung cakes? ______ [days from now]`,
         
         f_11_coal_compare_collect_freq_inlockdown = `f_11  As compared to before the lockdown, has your household been collecting coal more, the same, or less frequently than before?`,
         f_12_coal_compare_collect_amt_inlockdown = `f_12  As compared to before the lockdown, has your household been collecting coal more, the same, or less in a typical trip than before?`,
         f_13_coal_collect_location_inlockdown = `f_13  Where have you gone to get coal during lockdown?`,
         f_13_1_1_nocoal_havefuel = `f_13_1_1  I have not run out of coal`,
         f_13_1_2_nocoal_notusing = `f_13_1_2  I have not been using coal for cooking during lockdown`,
         f_13_1_3_nocoal_nomoney = `f_13_1_3  Did not have money available`,
         f_13_1_4_nocoal_didnotwanttoleave = `f_13_1_4  Did not want to leave household to get coal`,
         f_13_1_5_nocoal_normalspotunavailable = `f_13_1_5   Normal coal buying location not available`,
         f_13_1_6_nocoal_cantleave = `f_13_1_6  Was not allowed to leave household to get coal`,
         f_13_1_7_nocoal_other = `f_13_1_other specify`,
         
         f_14_coal_compare_collect_freq_recalllockdown = `f_14  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect coal more, the same, or less frequently than before?`,
         f_15_coal_compare_collect_amt_recalllockdown = `f_15  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect the same, or less in a typical trip than before?`,
         f_16_coal_compare_collect_location_recalllockdown = `f_16  Thinking back to during the lockdown, where did you go to get coal?`,
         
         g_1_lpg_refill_cost_compare_inlockdown = `g_1_1  Since the lockdown has begun, how does the price of an LPG cylinder refill compare to before?`,
         g_1_lpg_refill_cost_compare_reaclllockdown = `g_1_2   Thinking back to during the lockdown, in comparison with before the lockdown, how did the price of an LPG cylinder refill compare to before?`,
         g_2_lpg_refill_difficulty_inlockdown = `g_2  Since the lockdown began, is it now easier, more difficult, or the same difficulty of acquiring an LPG cylinder refill?`,
         g_3_1_like_using_lpg_more = `g_3  Do you agree or disagree with the following statement: Since the lockdown has begun, we like to cook with gas more than before.`,
         g_3_1_1_like_using_lpg_more_valuefastcooking = `g_3_1_1  We value faster cooking with LPG more now during lockdown`,
         g_3_1_2_like_using_lpg_more_cheapernow = `g_3_1_2   LPG is cheaper now`,
         g_3_1_3_like_using_lpg_more_accessiblenow = `g_3_1_3   LPG is more accessible now`,
         g_3_1_4_like_using_lpg_more_threecylpolicy = `g_3_1_4   Three free cylinder policy`,
         g_3_1_5_like_using_lpg_more_lessbiomassnow= `g_3_1_5  Household has less biomass now`,
         g_3_1_6_like_using_lpg_more_biomassacquireharder = `g_3_1_6   Household can acquire biomass less easily now`,
         g_3_1_7_like_using_lpg_more_tastepreferenceforlpg = `g_3_1_7  Household preferences favor the taste of food cooked with LPG`,
         g_3_1_8_like_using_lpg_more_tastepreferenceawayfirewood = `g_3_1_8  Household preferences shifting away from the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_1_9_like_using_lpg_more_prefercooklpg = `g_3_1_9  Household preferences favor the experience of cooking with LPG`,
         g_3_1_10_like_using_lpg_more_awaycookfirewood = `g_3_1_10  Household preferences shifting away the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_1_11_like_using_lpg_more_other = `g_3_1_other specify`,
         
         g_3_2_1_like_using_lpg_less_morecostly = `g_3_2_1   LPG is more expensive now`,
         g_3_2_2_like_using_lpg_less_lessaccessible = `g_3_2_2   LPG is less accessible now`,
         g_3_2_3_like_using_lpg_less_morebiomassnow = `g_3_2_3  Household has more biomass now`,
         g_3_2_4_like_using_lpg_less_tastepreferenceforfirewood = `g_3_2_4  Household preferences favor the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_2_5_like_using_lpg_less_tastepreferenceawaylpg = `g_3_2_5  Household does not prefer the taste of food cooked with LPG`,
         g_3_2_6_like_using_lpg_less_prefercookfirewood = `g_3_2_6 Household preferences favor the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_2_7_like_using_lpg_less_awaycooklpg = `g_3_2_7  Household does not prefer the experience of cooking with LPG`,
         g_3_2_8_like_using_lpg_less_other = `g_3_2_other specify`,
         
         h_1_threecylinder_aware = `h_1   As of April 1, 2020, the Government of India has made three free LPG cylinder refills available to Ujjwala beneficiaries. Prior to our conversation, were you or anybody in this household aware of this policy?`,
         h_2_threecylinder_aware_how = `h_2   How did you or anybody in the household become aware of this program/policy?`,
         h_2_threecylinder_aware_how_other = `h_2_other specify`,
         h_3_lpg_refill_subsidy_deposited = `h_3  Have you received an LPG refill subsidy deposited into your bank account?`,
         h_4_obtained_free_cylinder = `h_4  Have you obtained or received any of these three free cylinders?`,
         h_4_1_obtained_free_cylinder_number = `h_4_1  How many such free refills have you received? ______ [# refills; MAXIMUM NUMERIC VALUE OF 5]`,
         h_4_2_free_cylinder_process_convenience = `h_4_2  Did you find the process as convenient as acquiring a typical refill?`,
         h_4_2_1_process_difficult_fullpriceatsale = `h_4_2_1_1   Having to pay the full price at the time of sale is difficult`,
         h_4_2_2_process_difficult_longgetsubsidy = `h_4_2_1_2   It took longer to receive the subsidy/stimulus in the bank account`,
         h_4_2_2_process_difficult_moredifficultrefill = `h_4_2_1_3  It was more difficult to get to where I refilled the cylinder as compared to before due to travel restrictions`,
         h_4_2_2_process_difficult_policyconfusionatsale = `h_4_2_1_4  There was confusion about the policy at the point of sale`,
         h_4_2_2_process_difficult_other = `h_4_2_1_other specify`,
         h_5_threecylinder_use_future = `h_5   Do you plan to take advantage of the program in the future?`,
         h_6_threecylinder_use_future = `h_6   Do you plan to take advantage of the program in the future?`,
         
         i_1_covid_threatlevel = `i_1  What level of threat do you think COVID-19 poses to you or your family?`,
         i_2_covid_followguidelines = `i_2  In general, to what extent are people in your village following government guidelines about physical distancing and lockdown?`,
         i_3_covid_firewood_increaserisk = `i_3   Do you agree or disagree with the following statement: Cooking with firewood increases risk of COVID-related serious illness or death?`,
         i_4_1_covid_lpg_reducerisk_choice = `i_4_1 If medical research finds that LPG use reduces risk of COVID related serious illness, what would best describe your situation regarding LPG use and other fuels as applicable in the future for household needs?`,
         i_4_1_covid_firewood_increaserisk_choice = `i_4_2 Suppose that medical experts find that using LPG more, and the Chula less, reduces risk of getting very sick from COVID. What would best describe your future plans for acquiring and then using LPG?`,
         
  ) %>% 
  na_if(-99) %>% 
  mutate(date_interview = ymd(convertToDate(date_interview)),
         start_time_interview = ymd_hms(convertToDateTime(start_time_interview)),
         end_time_interview = ymd_hms(convertToDateTime(end_time_interview)))
  
# for whatever reason, this column didn't like to get renamed in the rename function.
# have to call it by number directly
# repeat the process for all rounds
colnames(jcovid1_1)[136] <- "f_3_firewood_compare_reserve_amt_inlockdown" 

# Round 2 -------
jcovid2_1 <- jcovid2 %>%
  rename(hhid = `hh_id_ Household ID_Baseline IDs`,
         age = `age_What is your age? _________ [years]`,
         age1 = `age_1_What is your age? _________ [years]`,
         date_interview = `date_int_Date of Interview`,
         start_time_interview = `start`,
         end_time_interview = `end`,
         
         b_1_relation_to_hhead = `q_b_1  What is your relationship to the household head?`,
         b_2_is_primary_cook = `q_b_2  Are you the primary cook for the household?`,
         b_3_gender = `q_b_3  What is your gender?`,
         
         c_1_1_econ_hardship_difficulty_food = `c_1_1  In the past 7 days, has your family endured any of the following economic hardships due to COVID-19? [ASK ALL QUESTIONS]_Increased difficulty accessing food for the household\r\n`,
         c_1_2_econ_hardship_increase_prices = `c_1_2  Increased prices for necessary goods`,
         c_1_3_econ_hardship_reduced_income = `c_1_3 Reduced income from any form of economic activity`,
         c_1_4_econ_hardship_salary_employment_loss = `c_1_4  Loss of salaried employment`,
         c_1_5_econ_hardship_hourly_employment_loss = `c_1_5  Loss of hourly waged employment, or loss of daily waged employment`,
         c_1_6_econ_hardship_hourly_employment_reduced = `c_1_6  Reduced hours of employment, or reduced days of waged employment`,
         c_1_7_econ_hardship_other_cash_sources_reduced = `c_1_7_Reduced cash from any other sources, such as family members outside the household or government cash transfer programs`,
         c_1_8_econ_hardship_unable_tolook_employment = `c_1_8_Unable to look for employment, such as going to a town for seasonal labor`,
         
         c_2_hh_size_change = `c_2  Since the beginning of the coronavirus outbreak, has there been a change in the number of people sleeping in your household?`,
         c_2_1_hhsize_more_workerreturned_pandemic = `c_2_1_1_Somebody working elsewhere returned home because of the coronavirus outbreak`,
         c_2_2_hhsize_more_workerreturned_planned = `c_2_1_2_Somebody working elsewhere returned home, as was already planned`,
         c_2_3_hhsize_more_studentreturned_pandemic = `c_2_1_3_Somebody studying elsewhere returned home because of the coronavirus outbreak`,
         c_2_4_hhsize_more_studentreturned_planned = `c_2_1_4_ Somebody studying elsewhere returned home, as was already planned`,
         c_2_5_hhsize_more_other = `c_2_1_other specify`,
         c_2_1_hhsize_less_workerleft_pandemic = `c_2_2_1_Somebody that was living at home left to go work elsewhere, due to the coronavirus pandemic`,
         c_2_2_hhsize_less_workerleft_planned = `c_2_2_2_Somebody that was living at home left to go work elsewhere, as was already planned`,
         c_2_3_hhsize_less_studentleft_pandemic = `c_2_2_3_ Somebody that was living at home left to go study elsewhere, due to the coronavirus pandemic`,
         c_2_4_hhsize_less_studentleft_planned = `c_2_2_4_Somebody that was living at home left to go study elsewhere, as was already planned`,
         c_2_5_hhsize_less_other = `c_2_2_other specify`,
         
         c_3_lockdown_ago_weeks = `c_3 How long ago did your block experience orders to restrict time outdoors due to covid-19? _____ [weeks]`,
         c_4_change_lockdown_since = `c_4  Has there been a change in orders to restrict time outdoors in your area since then?`,
         
         d_0_1_primary_lighting_fourdays = `d_0_1  In the last four days, what has been the primary source of lighting in your household?`,
         d_0_1_primary_lighting_other = `d_0_1_other specify`,
         
         d_0_all_lighting_grid = `d_0_1   Grid electricity`,
         d_0_all_lighting_kerosene = `d_0_2  Kerosene lamp/lantern`,
         d_0_all_lighting_microgrid = `d_0_3  Micro-grid`,
         d_0_all_lighting_solar = `d_0_4   Solar home system or solar lantern`,
         d_0_all_lighting_other = `d_0_other specify`,
         
         d_0_2_has_kerosene = `d_0_2  Does your household have kerosene lamps for lighting?`,
         d_0_2_1_1_not_used_kerosene_nofuel = `d_0_2_1_1  No kerosene fuel in the household`,
         d_0_2_1_2_not_used_kerosene_conservingfuel = `d_0_2_1_2  Running low on kerosene fuel in the household and saving it`,
         d_0_2_1_3_not_used_kerosene_unablebuy = `d_0_2_1_3   Unable to purchase kerosene from ration shop or usual place of purchase`,
         d_0_2_1_4_not_used_kerosene_notgoodlight = `d_0_2_1_4  Kerosene is not a good source of light`,
         d_0_2_1_5_not_used_kerosene_unsafe = `d_0_2_1_5  Kerosene is not safe`,
         d_0_2_1_6_not_used_kerosene_hasbetter = `d_0_2_1_6  No need because we have better forms of lighting`,
         d_0_2_1_7_not_used_kerosene_broken = `d_0_2_1_7   Kerosene lamps are broken`,
         d_0_2_1_8_not_used_kerosene_other = `d_0_2_1_other specify`,
         
         d_0_3_1_kerosene_use_compare = `d_0_3_1  Thinking back to before the lockdown, are you now using kerosene for lighting more, the same, or less than before? [Note to surveyor: Do not read options unless clarification needed]`,
         d_0_3_2_kerosene_use_compare_hours = `d_0_3_2  Thinking back to during the lockdown, in comparison to before lockdown, did you use kerosene for lighting for the same number of hours, for more hours, or for fewer hours? [do not read options unless clarification needed]`,
         d_0_3_4_kerosene_use_hours = `d_0_3_4  n the last four days, in a typical day, how many hours a day did you have at least one kerosene lamp on for lighting? [NUMBER OF HOURS DURING WHICH AT LEAST ONE LAMP IS ON] ______________ [HOURS/DAY]`,
         
         d_2_primary_cook_fuel = `d_2  In the last four days, what has been your primary cooking fuel?`,
         d_2_primary_cook_fuel_other = `d_2_other specify`,
         
         d_1_1_firewood = `d_1_1  Firewood and chips`,
         d_1_2_any_cook_fuel_agresidue = `d_1_2  Agricultural or crop residue`,
         d_1_3_any_cook_fuel_dung = `d_1_3  Animal waste / dung cakes`,
         d_1_4_any_cook_fuel_charcoal = `d_1_4  Charcoal`,
         d_1_5_any_cook_fuel_coal = `d_1_5  Coal`,
         d_1_6_any_cook_fuel_kerosene = `d_1_6  Kerosene / paraffin`,
         d_1_7_any_cook_fuel_alcohol = `d_1_7   Alcohol / ethanol`,
         d_1_8_any_cook_fuel_gasoline = `d_1_8  Gasoline / diesel (not in generator)`,
         d_1_9_any_cook_fuel_lpg = `d_1_9  Liquefied petroleum gas (LPG)`,
         d_1_10_any_cook_fuel_biogas = `d_1_10  Bio-gas`,
         d_1_11_any_cook_fuel_electricity = `d_1_11   Electricity`,
         d_1_12_any_cook_fuel_other = `d_1_other specify`,
         
         d_3_has_lpg = `d_3  Does your household have an LPG connection?`,
         d_3_1_1_not_used_lpg_nofuel =`d_3_1_1  No LPG fuel in the household`,
         d_3_1_2_not_used_lpg_conservingfuel =`d_3_1_2  Running low on LPG fuel in the household and saving it`,
         d_3_1_3_not_used_lpg_notcookusualdishes =`d_3_1_3  The households has not cooked the usual dishes that the LPG stove is used for`,
         d_3_1_4_not_used_lpg_otherfuels =`d_3_1_4  The household has lots of other fuels that we are using instead`,
         d_3_1_5_not_used_lpg_notlikenow =`d_3_1_5   We do not like to use the LPG stove these days`,
         d_3_1_6_not_used_lpg_fearful =`d_3_1_6  Fear of using the LPG stove`,
         d_3_1_7_not_used_lpg_usualcookisnotcook =`d_3_1_7   The person that normally cooks using LPG has not been cooking`,
         d_3_1_8_not_used_lpg_broken = `d_3_1_8  The LPG stove is broken and cannot be used`,
         d_3_1_9_not_used_lpg_other = `d_3_1_other specify`,
         
         d_4_lpg_via_pmuy = `d_4  Did you receive the LPG connection under Pradhan Mantri Ujjwala Yojana (PMUY)?`,
         d_5_multiple_cylinders = `d_5  Do you have more than one gas cylinder in your household?`,
         d_5_1_multiple_cylinders_sizes = `d_5_1  What size are the LPG cylinders you currently have?`,
         d_5_2_one_cylinder_size = `d_5_2_What size is the LPG cylinder you currently have?`,
         d_5_3_singleordouble_connection = `d_5_3_Do you have a single or double bottle connection from your LPG provider (LPG Agency)?`,
         d_5_4_second_cylinder_source = `d_5_4_If single bottle connection, so from whom did you take the second LPG cylinder?`,
         
         d_6_fourdays_typical_number_meals = `d_6  In the last four days, during a typical day, about how many meals have been cooked in your house? (Note to interviewer: this question seeks to estimate the average number of meals cooked per day -- not a sum over the past four days) _________ [# meals per day]`,
         d_7_fourdays_hours_cook = `d_7  In the last four days, during a typical day, how much time is spent cooking? _________ [# hours per day]All meals combined — total number of hours cooking / stove on in the entire day`,
         d_8_1_cook_hours_compare_inlockdown = `d_8_1  Thinking back to before the lockdown, are you now cooking in total for more hours, for the same number of hours, or for fewer hours as compared to before?`,
         d_8_2_cook_hours_compare_recalllockdown = `d_8_2  During the lockdown, in comparison with before the lockdown, did you cook for more hours, for the same number of hours, or for fewer hours overall? [do not read options unless clarification needed]`,
         
         d_9_lpg_use_compare = `d_9  Compared to before lockdown, how are you using LPG? If something has changed, please tell us. [READ OPTIONS]`,
         d_10_pollutingfuel_use_compare = `d_10  Thinking back to before the lockdown, how would you describe your use of the traditional fuels like firewood, coal, dung, agricultural residues, and kerosene now? [READ OPTIONS]`,
         
         e_1_1_refill_lpg_inlockdown = `e_1_1  Since the lockdown began, have you refilled your LPG cylinder?`,
         e_1_2_refill_lpg_recalllockdown = `e_1_2 During the period of the lockdown, did you refill your LPG cylinder?`,
         
         e_2_refill_lpg_wksago = `e_2  How many weeks ago did you last refill your large LPG cylinder? ______ [# weeks]`,
         e_3_refill_source = `e_3  Where did you get that refill from?`,
         e_3_refill_source_other = `e_3_other specify`,
         e_4_1_refill_differences_nodelivery = `e_4_1 No delivery as compared to usual delivery`,
         e_4_2_refill_differences_deliverynow = `e_4_2  Delivery as compared to not usually getting delivery`,
         e_4_3_refill_differences_longerwait = `e_4_3   Longer wait as compared to usual at distributor shop`,
         e_4_4_refill_differences_shorterwait = `e_4_4  Shorter wait as compared to usual at distributor shop`,
         e_4_5_refill_differences_pickupfurther = `e_4_5  Village pick-up point was further away than usual`,
         e_4_6_refill_differences_pickupcloser = `e_4_6  Village pick-up point was closer than usual`,
         e_4_7_refill_differences_none = `e_4_7_There were no differences`,
         e_4_8_refill_differences_other = `e_4_other specify`,
         
         e_5_subsidy_time_compare = `e_5  Thinking back to before the lockdown, does it take less time, more time, or the same amount of time to receive the subsidy amount in your bank account?`,
         e_6_lpgrefill_cost = `e_6  How much did you pay at the time of purchase for your last LPG cylinder? ______ [INR]`,
         e_7_1_nolpg_refill_didnotrunout = `e_7_1  Did not run out of gas`,
         e_7_2_nolpg_refill_rationed = `e_7_2  Rationed gas so I did not run out`,
         e_7_3_nolpg_refill_nomoney = `e_7_3   Did not have money available`,
         e_7_4_nolpg_refill_didnotwanttoleave = `e_7_4  Did not want to leave household to get refill`,
         e_7_5_nolpg_refill_deliveryunavailable = `e_7_5  Normal gas delivery not available`,
         e_7_6_nolpg_refill_couldnotleave = `e_7_6 Was not allowed to leave household to get refill`,
         e_7_7_nolpg_refill_other = `e_7_other specify`,
         
         e_8_refill_next_wks = `e_8  When do you expect to next refill an LPG cylinder? ______ [# weeks]`,
         
         f_1_firewood_compare_collect_freq_inlockdown = `f_1 As compared to before the lockdown, has your household been collecting firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_2_firewood_compare_collect_amt_inlockdown = `f_2 As compared to before the lockdown, has your household collected more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         # f_3_firewood_compare_reserve_amt_inlockdown = `f_3 As compared to before the lockdown, does the household now have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically? [Note for surveyor: This question refers to the amount/volume/weight of fuel being stored in the household. Households often have some amount of fuel being stored that they then are able to use for cooking at any given point. Here, we ask if they have approximately the same, more, or less fuel stored in the household as compared to before.]`,
         f_4_firewood_compare_collect_difficulty_inlockdown = `f_4  As compared to before the lockdown, does the household now have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_5_firewood_compare_collect_freq_recalllockdown = `f_5  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_6_firewood_compare_collect_amt_recalllockdown = `f_6  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         f_7_firewood_compare_reserve_amt_recalllockdown = `f_7  Thinking back to during the lockdown, in comparison with before the lockdown, did your household have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically?`,
         f_8_firewood_compare_collect_amt_recalllockdown = `f_8  Thinking back to during the lockdown, as compared to non-lockdown times, did your household have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_9_firewood_collect_last_days = `f_9  When was the last time a household member collected firewood, twigs, agricultural residues, or dung cakes? ______ [days ago]`,
         f_10_firewood_collect_next_days = `f_10  When do you expect that a household member will next go for collecting firewood, twigs, agricultural residues, or dung cakes? ______ [days from now]`,
         
         f_11_coal_compare_collect_freq_inlockdown = `f_11  As compared to before the lockdown, has your household been collecting coal more, the same, or less frequently than before?`,
         f_12_coal_compare_collect_amt_inlockdown = `f_12  As compared to before the lockdown, has your household been collecting coal more, the same, or less in a typical trip than before?`,
         f_13_coal_collect_location_inlockdown = `f_13  Where have you gone to get coal during lockdown?`,
         f_13_1_1_nocoal_havefuel = `f_13_1_1  I have not run out of coal`,
         f_13_1_2_nocoal_notusing = `f_13_1_2  I have not been using coal for cooking during lockdown`,
         f_13_1_3_nocoal_nomoney = `f_13_1_3  Did not have money available`,
         f_13_1_4_nocoal_didnotwanttoleave = `f_13_1_4  Did not want to leave household to get coal`,
         f_13_1_5_nocoal_normalspotunavailable = `f_13_1_5   Normal coal buying location not available`,
         f_13_1_6_nocoal_cantleave = `f_13_1_6  Was not allowed to leave household to get coal`,
         f_13_1_7_nocoal_other = `f_13_1_other specify`,
         
         f_14_coal_compare_collect_freq_recalllockdown = `f_14  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect coal more, the same, or less frequently than before?`,
         f_15_coal_compare_collect_amt_recalllockdown = `f_15  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect the same, or less in a typical trip than before?`,
         f_16_coal_compare_collect_location_recalllockdown = `f_16  Thinking back to during the lockdown, where did you go to get coal?`,
         
         g_1_lpg_refill_cost_compare_inlockdown = `g_1_1  Since the lockdown has begun, how does the price of an LPG cylinder refill compare to before?`,
         g_1_lpg_refill_cost_compare_reaclllockdown = `g_1_2   Thinking back to during the lockdown, in comparison with before the lockdown, how did the price of an LPG cylinder refill compare to before?`,
         g_2_lpg_refill_difficulty_inlockdown = `g_2  Since the lockdown began, is it now easier, more difficult, or the same difficulty of acquiring an LPG cylinder refill?`,
         g_3_1_like_using_lpg_more = `g_3  Do you agree or disagree with the following statement: Since the lockdown has begun, we like to cook with gas more than before.`,
         g_3_1_1_like_using_lpg_more_valuefastcooking = `g_3_1_1  We value faster cooking with LPG more now during lockdown`,
         g_3_1_2_like_using_lpg_more_cheapernow = `g_3_1_2   LPG is cheaper now`,
         g_3_1_3_like_using_lpg_more_accessiblenow = `g_3_1_3   LPG is more accessible now`,
         g_3_1_4_like_using_lpg_more_threecylpolicy = `g_3_1_4   Three free cylinder policy`,
         g_3_1_5_like_using_lpg_more_lessbiomassnow= `g_3_1_5  Household has less biomass now`,
         g_3_1_6_like_using_lpg_more_biomassacquireharder = `g_3_1_6   Household can acquire biomass less easily now`,
         g_3_1_7_like_using_lpg_more_tastepreferenceforlpg = `g_3_1_7  Household preferences favor the taste of food cooked with LPG`,
         g_3_1_8_like_using_lpg_more_tastepreferenceawayfirewood = `g_3_1_8  Household preferences shifting away from the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_1_9_like_using_lpg_more_prefercooklpg = `g_3_1_9  Household preferences favor the experience of cooking with LPG`,
         g_3_1_10_like_using_lpg_more_awaycookfirewood = `g_3_1_10  Household preferences shifting away the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_1_11_like_using_lpg_more_other = `g_3_1_other specify`,
         
         g_3_2_1_like_using_lpg_less_morecostly = `g_3_2_1   LPG is more expensive now`,
         g_3_2_2_like_using_lpg_less_lessaccessible = `g_3_2_2   LPG is less accessible now`,
         g_3_2_3_like_using_lpg_less_morebiomassnow = `g_3_2_3  Household has more biomass now`,
         g_3_2_4_like_using_lpg_less_tastepreferenceforfirewood = `g_3_2_4  Household preferences favor the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_2_5_like_using_lpg_less_tastepreferenceawaylpg = `g_3_2_5  Household does not prefer the taste of food cooked with LPG`,
         g_3_2_6_like_using_lpg_less_prefercookfirewood = `g_3_2_6 Household preferences favor the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_2_7_like_using_lpg_less_awaycooklpg = `g_3_2_7  Household does not prefer the experience of cooking with LPG`,
         g_3_2_8_like_using_lpg_less_other = `g_3_2_other specify`,
         
         h_1_threecylinder_aware = `h_1   As of April 1, 2020, the Government of India has made three free LPG cylinder refills available to Ujjwala beneficiaries. Prior to our conversation, were you or anybody in this household aware of this policy?`,
         h_2_threecylinder_aware_how = `h_2   How did you or anybody in the household become aware of this program/policy?`,
         h_2_threecylinder_aware_how_other = `h_2_other specify`,
         h_3_lpg_refill_subsidy_deposited = `h_3  Have you received an LPG refill subsidy deposited into your bank account?`,
         h_4_obtained_free_cylinder = `h_4  Have you obtained or received any of these three free cylinders?`,
         h_4_1_obtained_free_cylinder_number = `h_4_1  How many such free refills have you received? ______ [# refills; MAXIMUM NUMERIC VALUE OF 5]`,
         h_4_2_free_cylinder_process_convenience = `h_4_2  Did you find the process as convenient as acquiring a typical refill?`,
         h_4_2_1_process_difficult_fullpriceatsale = `h_4_2_1_1   Having to pay the full price at the time of sale is difficult`,
         h_4_2_2_process_difficult_longgetsubsidy = `h_4_2_1_2   It took longer to receive the subsidy/stimulus in the bank account`,
         h_4_2_2_process_difficult_moredifficultrefill = `h_4_2_1_3  It was more difficult to get to where I refilled the cylinder as compared to before due to travel restrictions`,
         h_4_2_2_process_difficult_policyconfusionatsale = `h_4_2_1_4  There was confusion about the policy at the point of sale`,
         h_4_2_2_process_difficult_other = `h_4_2_1_other specify`,
         h_5_threecylinder_use_future = `h_5   Do you plan to take advantage of the program in the future?`,
         h_6_threecylinder_use_future = `h_6   Do you plan to take advantage of the program in the future?`,
         
         i_1_covid_threatlevel = `i_1  What level of threat do you think COVID-19 poses to you or your family?`,
         i_2_covid_followguidelines = `i_2  In general, to what extent are people in your village following government guidelines about physical distancing and lockdown?`,
         i_3_covid_firewood_increaserisk = `i_3   Do you agree or disagree with the following statement: Cooking with firewood increases risk of COVID-related serious illness or death?`,
         i_4_1_covid_lpg_reducerisk_choice = `i_4_1 If medical research finds that LPG use reduces risk of COVID related serious illness, what would best describe your situation regarding LPG use and other fuels as applicable in the future for household needs?`,
         i_4_1_covid_firewood_increaserisk_choice = `i_4_2 Suppose that medical experts find that using LPG more, and the Chula less, reduces risk of getting very sick from COVID. What would best describe your future plans for acquiring and then using LPG?`,
         
  ) %>% 
  na_if(-99) %>% 
  mutate(date_interview = ymd(convertToDate(date_interview)),
         start_time_interview = ymd_hms(convertToDateTime(start_time_interview)),
         end_time_interview = ymd_hms(convertToDateTime(end_time_interview)))

colnames(jcovid2_1)[152] <- "f_3_firewood_compare_reserve_amt_inlockdown" 

# Round 3 -------
jcovid3_1 <- jcovid3 %>%
  rename(hhid = `hh_id_ Household ID_Baseline IDs`,
         age = `age_What is your age? _________ [years]`,
         age1 = `age_1_What is your age? _________ [years]`,
         date_interview = `date_int_Date of Interview`,
         start_time_interview = `start`,
         end_time_interview = `end`,
         
         b_1_relation_to_hhead = `q_b_1  What is your relationship to the household head?`,
         b_2_is_primary_cook = `q_b_2  Are you the primary cook for the household?`,
         b_3_gender = `q_b_3  What is your gender?`,
         
         c_1_1_econ_hardship_difficulty_food = `c_1_1  In the past 7 days, has your family endured any of the following economic hardships due to COVID-19? [ASK ALL QUESTIONS]_Increased difficulty accessing food for the household\r\n`,
         c_1_2_econ_hardship_increase_prices = `c_1_2  Increased prices for necessary goods`,
         c_1_3_econ_hardship_reduced_income = `c_1_3 Reduced income from any form of economic activity`,
         c_1_4_econ_hardship_salary_employment_loss = `c_1_4  Loss of salaried employment`,
         c_1_5_econ_hardship_hourly_employment_loss = `c_1_5  Loss of hourly waged employment, or loss of daily waged employment`,
         c_1_6_econ_hardship_hourly_employment_reduced = `c_1_6  Reduced hours of employment, or reduced days of waged employment`,
         c_1_7_econ_hardship_other_cash_sources_reduced = `c_1_7_Reduced cash from any other sources, such as family members outside the household or government cash transfer programs`,
         c_1_8_econ_hardship_unable_tolook_employment = `c_1_8_Unable to look for employment, such as going to a town for seasonal labor`,
         
         c_2_hh_size_change = `c_2  Since the beginning of the coronavirus outbreak, has there been a change in the number of people sleeping in your household?`,
         c_2_1_hhsize_more_workerreturned_pandemic = `c_2_1_1_Somebody working elsewhere returned home because of the coronavirus outbreak`,
         c_2_2_hhsize_more_workerreturned_planned = `c_2_1_2_Somebody working elsewhere returned home, as was already planned`,
         c_2_3_hhsize_more_studentreturned_pandemic = `c_2_1_3_Somebody studying elsewhere returned home because of the coronavirus outbreak`,
         c_2_4_hhsize_more_studentreturned_planned = `c_2_1_4_ Somebody studying elsewhere returned home, as was already planned`,
         c_2_5_hhsize_more_other = `c_2_1_other specify`,
         c_2_1_hhsize_less_workerleft_pandemic = `c_2_2_1_Somebody that was living at home left to go work elsewhere, due to the coronavirus pandemic`,
         c_2_2_hhsize_less_workerleft_planned = `c_2_2_2_Somebody that was living at home left to go work elsewhere, as was already planned`,
         c_2_3_hhsize_less_studentleft_pandemic = `c_2_2_3_ Somebody that was living at home left to go study elsewhere, due to the coronavirus pandemic`,
         c_2_4_hhsize_less_studentleft_planned = `c_2_2_4_Somebody that was living at home left to go study elsewhere, as was already planned`,
         c_2_5_hhsize_less_other = `c_2_2_other specify`,
         
         c_3_lockdown_ago_weeks = `c_3 How long ago did your block experience orders to restrict time outdoors due to covid-19? _____ [weeks]`,
         c_4_change_lockdown_since = `c_4  Has there been a change in orders to restrict time outdoors in your area since then?`,
         
         d_0_1_primary_lighting_fourdays = `d_0_1  In the last four days, what has been the primary source of lighting in your household?`,
         d_0_1_primary_lighting_other = `d_0_1_other specify`,
         
         d_0_all_lighting_grid = `d_0_1   Grid electricity`,
         d_0_all_lighting_kerosene = `d_0_2  Kerosene lamp/lantern`,
         d_0_all_lighting_microgrid = `d_0_3  Micro-grid`,
         d_0_all_lighting_solar = `d_0_4   Solar home system or solar lantern`,
         d_0_all_lighting_other = `d_0_other specify`,
         
         d_0_2_has_kerosene = `d_0_2  Does your household have kerosene lamps for lighting?`,
         d_0_2_1_1_not_used_kerosene_nofuel = `d_0_2_1_1  No kerosene fuel in the household`,
         d_0_2_1_2_not_used_kerosene_conservingfuel = `d_0_2_1_2  Running low on kerosene fuel in the household and saving it`,
         d_0_2_1_3_not_used_kerosene_unablebuy = `d_0_2_1_3   Unable to purchase kerosene from ration shop or usual place of purchase`,
         d_0_2_1_4_not_used_kerosene_notgoodlight = `d_0_2_1_4  Kerosene is not a good source of light`,
         d_0_2_1_5_not_used_kerosene_unsafe = `d_0_2_1_5  Kerosene is not safe`,
         d_0_2_1_6_not_used_kerosene_hasbetter = `d_0_2_1_6  No need because we have better forms of lighting`,
         d_0_2_1_7_not_used_kerosene_broken = `d_0_2_1_7   Kerosene lamps are broken`,
         d_0_2_1_8_not_used_kerosene_other = `d_0_2_1_other specify`,
         
         d_0_3_1_kerosene_use_compare = `d_0_3_1  Thinking back to before the lockdown, are you now using kerosene for lighting more, the same, or less than before? [Note to surveyor: Do not read options unless clarification needed]`,
         d_0_3_2_kerosene_use_compare_hours = `d_0_3_2  Thinking back to during the lockdown, in comparison to before lockdown, did you use kerosene for lighting for the same number of hours, for more hours, or for fewer hours? [do not read options unless clarification needed]`,
         d_0_3_4_kerosene_use_hours = `d_0_3_4  n the last four days, in a typical day, how many hours a day did you have at least one kerosene lamp on for lighting? [NUMBER OF HOURS DURING WHICH AT LEAST ONE LAMP IS ON] ______________ [HOURS/DAY]`,
         
         d_2_primary_cook_fuel = `d_2  In the last four days, what has been your primary cooking fuel?`,
         d_2_primary_cook_fuel_other = `d_2_other specify`,
         
         d_1_1_firewood = `d_1_1  Firewood and chips`,
         d_1_2_any_cook_fuel_agresidue = `d_1_2  Agricultural or crop residue`,
         d_1_3_any_cook_fuel_dung = `d_1_3  Animal waste / dung cakes`,
         d_1_4_any_cook_fuel_charcoal = `d_1_4  Charcoal`,
         d_1_5_any_cook_fuel_coal = `d_1_5  Coal`,
         d_1_6_any_cook_fuel_kerosene = `d_1_6  Kerosene / paraffin`,
         d_1_7_any_cook_fuel_alcohol = `d_1_7   Alcohol / ethanol`,
         d_1_8_any_cook_fuel_gasoline = `d_1_8  Gasoline / diesel (not in generator)`,
         d_1_9_any_cook_fuel_lpg = `d_1_9  Liquefied petroleum gas (LPG)`,
         d_1_10_any_cook_fuel_biogas = `d_1_10  Bio-gas`,
         d_1_11_any_cook_fuel_electricity = `d_1_11   Electricity`,
         d_1_12_any_cook_fuel_other = `d_1_other specify`,
         
         d_3_has_lpg = `d_3  Does your household have an LPG connection?`,
         d_3_1_1_not_used_lpg_nofuel =`d_3_1_1  No LPG fuel in the household`,
         d_3_1_2_not_used_lpg_conservingfuel =`d_3_1_2  Running low on LPG fuel in the household and saving it`,
         d_3_1_3_not_used_lpg_notcookusualdishes =`d_3_1_3  The households has not cooked the usual dishes that the LPG stove is used for`,
         d_3_1_4_not_used_lpg_otherfuels =`d_3_1_4  The household has lots of other fuels that we are using instead`,
         d_3_1_5_not_used_lpg_notlikenow =`d_3_1_5   We do not like to use the LPG stove these days`,
         d_3_1_6_not_used_lpg_fearful =`d_3_1_6  Fear of using the LPG stove`,
         d_3_1_7_not_used_lpg_usualcookisnotcook =`d_3_1_7   The person that normally cooks using LPG has not been cooking`,
         d_3_1_8_not_used_lpg_broken = `d_3_1_8  The LPG stove is broken and cannot be used`,
         d_3_1_9_not_used_lpg_other = `d_3_1_other specify`,
         
         d_4_lpg_via_pmuy = `d_4  Did you receive the LPG connection under Pradhan Mantri Ujjwala Yojana (PMUY)?`,
         d_5_multiple_cylinders = `d_5  Do you have more than one gas cylinder in your household?`,
         d_5_1_multiple_cylinders_sizes = `d_5_1  What size are the LPG cylinders you currently have?`,
         d_5_2_one_cylinder_size = `d_5_2_What size is the LPG cylinder you currently have?`,
         d_5_3_singleordouble_connection = `d_5_3_Do you have a single or double bottle connection from your LPG provider (LPG Agency)?`,
         d_5_4_second_cylinder_source = `d_5_4_If single bottle connection, so from whom did you take the second LPG cylinder?`,
         
         d_6_fourdays_typical_number_meals = `d_6  In the last four days, during a typical day, about how many meals have been cooked in your house? (Note to interviewer: this question seeks to estimate the average number of meals cooked per day -- not a sum over the past four days) _________ [# meals per day]`,
         d_7_fourdays_hours_cook = `d_7  In the last four days, during a typical day, how much time is spent cooking? _________ [# hours per day]All meals combined — total number of hours cooking / stove on in the entire day`,
         d_8_1_cook_hours_compare_inlockdown = `d_8_1  Thinking back to before the lockdown, are you now cooking in total for more hours, for the same number of hours, or for fewer hours as compared to before?`,
         d_8_2_cook_hours_compare_recalllockdown = `d_8_2  During the lockdown, in comparison with before the lockdown, did you cook for more hours, for the same number of hours, or for fewer hours overall? [do not read options unless clarification needed]`,
         
         d_9_lpg_use_compare = `d_9  Compared to before lockdown, how are you using LPG? If something has changed, please tell us. [READ OPTIONS]`,
         d_10_pollutingfuel_use_compare = `d_10  Thinking back to before the lockdown, how would you describe your use of the traditional fuels like firewood, coal, dung, agricultural residues, and kerosene now? [READ OPTIONS]`,
         
         e_1_1_refill_lpg_inlockdown = `e_1_1  Since the lockdown began, have you refilled your LPG cylinder?`,
         e_1_2_refill_lpg_recalllockdown = `e_1_2 During the period of the lockdown, did you refill your LPG cylinder?`,
         
         e_2_refill_lpg_wksago = `e_2  How many weeks ago did you last refill your large LPG cylinder? ______ [# weeks]`,
         e_3_refill_source = `e_3  Where did you get that refill from?`,
         e_3_refill_source_other = `e_3_other specify`,
         e_4_1_refill_differences_nodelivery = `e_4_1 No delivery as compared to usual delivery`,
         e_4_2_refill_differences_deliverynow = `e_4_2  Delivery as compared to not usually getting delivery`,
         e_4_3_refill_differences_longerwait = `e_4_3   Longer wait as compared to usual at distributor shop`,
         e_4_4_refill_differences_shorterwait = `e_4_4  Shorter wait as compared to usual at distributor shop`,
         e_4_5_refill_differences_pickupfurther = `e_4_5  Village pick-up point was further away than usual`,
         e_4_6_refill_differences_pickupcloser = `e_4_6  Village pick-up point was closer than usual`,
         e_4_7_refill_differences_none = `e_4_7_There were no differences`,
         e_4_8_refill_differences_other = `e_4_other specify`,
         
         e_5_subsidy_time_compare = `e_5  Thinking back to before the lockdown, does it take less time, more time, or the same amount of time to receive the subsidy amount in your bank account?`,
         e_6_lpgrefill_cost = `e_6  How much did you pay at the time of purchase for your last LPG cylinder? ______ [INR]`,
         e_7_1_nolpg_refill_didnotrunout = `e_7_1  Did not run out of gas`,
         e_7_2_nolpg_refill_rationed = `e_7_2  Rationed gas so I did not run out`,
         e_7_3_nolpg_refill_nomoney = `e_7_3   Did not have money available`,
         e_7_4_nolpg_refill_didnotwanttoleave = `e_7_4  Did not want to leave household to get refill`,
         e_7_5_nolpg_refill_deliveryunavailable = `e_7_5  Normal gas delivery not available`,
         e_7_6_nolpg_refill_couldnotleave = `e_7_6 Was not allowed to leave household to get refill`,
         e_7_7_nolpg_refill_other = `e_7_other specify`,
         
         e_8_refill_next_wks = `e_8  When do you expect to next refill an LPG cylinder? ______ [# weeks]`,
         
         f_1_firewood_compare_collect_freq_inlockdown = `f_1 As compared to before the lockdown, has your household been collecting firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_2_firewood_compare_collect_amt_inlockdown = `f_2 As compared to before the lockdown, has your household collected more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         # f_3_firewood_compare_reserve_amt_inlockdown = `f_3 As compared to before the lockdown, does the household now have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically? [Note for surveyor: This question refers to the amount/volume/weight of fuel being stored in the household. Households often have some amount of fuel being stored that they then are able to use for cooking at any given point. Here, we ask if they have approximately the same, more, or less fuel stored in the household as compared to before.]`,
         f_4_firewood_compare_collect_difficulty_inlockdown = `f_4  As compared to before the lockdown, does the household now have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_5_firewood_compare_collect_freq_recalllockdown = `f_5  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_6_firewood_compare_collect_amt_recalllockdown = `f_6  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         f_7_firewood_compare_reserve_amt_recalllockdown = `f_7  Thinking back to during the lockdown, in comparison with before the lockdown, did your household have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically?`,
         f_8_firewood_compare_collect_amt_recalllockdown = `f_8  Thinking back to during the lockdown, as compared to non-lockdown times, did your household have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_9_firewood_collect_last_days = `f_9  When was the last time a household member collected firewood, twigs, agricultural residues, or dung cakes? ______ [days ago]`,
         f_10_firewood_collect_next_days = `f_10  When do you expect that a household member will next go for collecting firewood, twigs, agricultural residues, or dung cakes? ______ [days from now]`,
         
         f_11_coal_compare_collect_freq_inlockdown = `f_11  As compared to before the lockdown, has your household been collecting coal more, the same, or less frequently than before?`,
         f_12_coal_compare_collect_amt_inlockdown = `f_12  As compared to before the lockdown, has your household been collecting coal more, the same, or less in a typical trip than before?`,
         f_13_coal_collect_location_inlockdown = `f_13  Where have you gone to get coal during lockdown?`,
         f_13_1_1_nocoal_havefuel = `f_13_1_1  I have not run out of coal`,
         f_13_1_2_nocoal_notusing = `f_13_1_2  I have not been using coal for cooking during lockdown`,
         f_13_1_3_nocoal_nomoney = `f_13_1_3  Did not have money available`,
         f_13_1_4_nocoal_didnotwanttoleave = `f_13_1_4  Did not want to leave household to get coal`,
         f_13_1_5_nocoal_normalspotunavailable = `f_13_1_5   Normal coal buying location not available`,
         f_13_1_6_nocoal_cantleave = `f_13_1_6  Was not allowed to leave household to get coal`,
         f_13_1_7_nocoal_other = `f_13_1_other specify`,
         
         f_14_coal_compare_collect_freq_recalllockdown = `f_14  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect coal more, the same, or less frequently than before?`,
         f_15_coal_compare_collect_amt_recalllockdown = `f_15  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect the same, or less in a typical trip than before?`,
         f_16_coal_compare_collect_location_recalllockdown = `f_16  Thinking back to during the lockdown, where did you go to get coal?`,
         
         g_1_lpg_refill_cost_compare_inlockdown = `g_1_1  Since the lockdown has begun, how does the price of an LPG cylinder refill compare to before?`,
         g_1_lpg_refill_cost_compare_reaclllockdown = `g_1_2   Thinking back to during the lockdown, in comparison with before the lockdown, how did the price of an LPG cylinder refill compare to before?`,
         g_2_lpg_refill_difficulty_inlockdown = `g_2  Since the lockdown began, is it now easier, more difficult, or the same difficulty of acquiring an LPG cylinder refill?`,
         g_3_1_like_using_lpg_more = `g_3  Do you agree or disagree with the following statement: Since the lockdown has begun, we like to cook with gas more than before.`,
         g_3_1_1_like_using_lpg_more_valuefastcooking = `g_3_1_1  We value faster cooking with LPG more now during lockdown`,
         g_3_1_2_like_using_lpg_more_cheapernow = `g_3_1_2   LPG is cheaper now`,
         g_3_1_3_like_using_lpg_more_accessiblenow = `g_3_1_3   LPG is more accessible now`,
         g_3_1_4_like_using_lpg_more_threecylpolicy = `g_3_1_4   Three free cylinder policy`,
         g_3_1_5_like_using_lpg_more_lessbiomassnow= `g_3_1_5  Household has less biomass now`,
         g_3_1_6_like_using_lpg_more_biomassacquireharder = `g_3_1_6   Household can acquire biomass less easily now`,
         g_3_1_7_like_using_lpg_more_tastepreferenceforlpg = `g_3_1_7  Household preferences favor the taste of food cooked with LPG`,
         g_3_1_8_like_using_lpg_more_tastepreferenceawayfirewood = `g_3_1_8  Household preferences shifting away from the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_1_9_like_using_lpg_more_prefercooklpg = `g_3_1_9  Household preferences favor the experience of cooking with LPG`,
         g_3_1_10_like_using_lpg_more_awaycookfirewood = `g_3_1_10  Household preferences shifting away the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_1_11_like_using_lpg_more_other = `g_3_1_other specify`,
         
         g_3_2_1_like_using_lpg_less_morecostly = `g_3_2_1   LPG is more expensive now`,
         g_3_2_2_like_using_lpg_less_lessaccessible = `g_3_2_2   LPG is less accessible now`,
         g_3_2_3_like_using_lpg_less_morebiomassnow = `g_3_2_3  Household has more biomass now`,
         g_3_2_4_like_using_lpg_less_tastepreferenceforfirewood = `g_3_2_4  Household preferences favor the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_2_5_like_using_lpg_less_tastepreferenceawaylpg = `g_3_2_5  Household does not prefer the taste of food cooked with LPG`,
         g_3_2_6_like_using_lpg_less_prefercookfirewood = `g_3_2_6 Household preferences favor the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_2_7_like_using_lpg_less_awaycooklpg = `g_3_2_7  Household does not prefer the experience of cooking with LPG`,
         g_3_2_8_like_using_lpg_less_other = `g_3_2_other specify`,
         
         h_1_threecylinder_aware = `h_1   As of April 1, 2020, the Government of India has made three free LPG cylinder refills available to Ujjwala beneficiaries. Prior to our conversation, were you or anybody in this household aware of this policy?`,
         h_2_threecylinder_aware_how = `h_2   How did you or anybody in the household become aware of this program/policy?`,
         h_2_threecylinder_aware_how_other = `h_2_other specify`,
         h_3_lpg_refill_subsidy_deposited = `h_3  Have you received an LPG refill subsidy deposited into your bank account?`,
         h_4_obtained_free_cylinder = `h_4  Have you obtained or received any of these three free cylinders?`,
         h_4_1_obtained_free_cylinder_number = `h_4_1  How many such free refills have you received? ______ [# refills; MAXIMUM NUMERIC VALUE OF 5]`,
         h_4_2_free_cylinder_process_convenience = `h_4_2  Did you find the process as convenient as acquiring a typical refill?`,
         h_4_2_1_process_difficult_fullpriceatsale = `h_4_2_1_1   Having to pay the full price at the time of sale is difficult`,
         h_4_2_2_process_difficult_longgetsubsidy = `h_4_2_1_2   It took longer to receive the subsidy/stimulus in the bank account`,
         h_4_2_2_process_difficult_moredifficultrefill = `h_4_2_1_3  It was more difficult to get to where I refilled the cylinder as compared to before due to travel restrictions`,
         h_4_2_2_process_difficult_policyconfusionatsale = `h_4_2_1_4  There was confusion about the policy at the point of sale`,
         h_4_2_2_process_difficult_other = `h_4_2_1_other specify`,
         h_5_threecylinder_use_future = `h_5   Do you plan to take advantage of the program in the future?`,
         h_6_threecylinder_use_future = `h_6   Do you plan to take advantage of the program in the future?`,
         
         i_1_covid_threatlevel = `i_1  What level of threat do you think COVID-19 poses to you or your family?`,
         i_2_covid_followguidelines = `i_2  In general, to what extent are people in your village following government guidelines about physical distancing and lockdown?`,
         i_3_covid_firewood_increaserisk = `i_3   Do you agree or disagree with the following statement: Cooking with firewood increases risk of COVID-related serious illness or death?`,
         i_4_1_covid_lpg_reducerisk_choice = `i_4_1 If medical research finds that LPG use reduces risk of COVID related serious illness, what would best describe your situation regarding LPG use and other fuels as applicable in the future for household needs?`,
         i_4_1_covid_firewood_increaserisk_choice = `i_4_2 Suppose that medical experts find that using LPG more, and the Chula less, reduces risk of getting very sick from COVID. What would best describe your future plans for acquiring and then using LPG?`,
         
  ) %>% 
  na_if(-99)  %>% 
  mutate(date_interview = ymd(convertToDate(date_interview)),
         start_time_interview = ymd_hms(convertToDateTime(start_time_interview)),
         end_time_interview = ymd_hms(convertToDateTime(end_time_interview)))

colnames(jcovid3_1)[152] <- "f_3_firewood_compare_reserve_amt_inlockdown" 


# Round 4 -------
jcovid4_1 <- jcovid4 %>%
  rename(hhid = `hh_id_ Household ID_Baseline IDs`,
         age = `age_What is your age? _________ [years]`,
         age1 = `age_1_What is your age? _________ [years]`,
         date_interview = `date_int_Date of Interview`,
         start_time_interview = `start`,
         end_time_interview = `end`,
         
         b_1_relation_to_hhead = `q_b_1  What is your relationship to the household head?`,
         b_2_is_primary_cook = `q_b_2  Are you the primary cook for the household?`,
         b_3_gender = `q_b_3  What is your gender?`,
         
         c_1_1_econ_hardship_difficulty_food = `c_1_1  In the past 7 days, has your family endured any of the following economic hardships due to COVID-19? [ASK ALL QUESTIONS]_Increased difficulty accessing food for the household\r\n`,
         c_1_2_econ_hardship_increase_prices = `c_1_2  Increased prices for necessary goods`,
         c_1_3_econ_hardship_reduced_income = `c_1_3 Reduced income from any form of economic activity`,
         c_1_4_econ_hardship_salary_employment_loss = `c_1_4  Loss of salaried employment`,
         c_1_5_econ_hardship_hourly_employment_loss = `c_1_5  Loss of hourly waged employment, or loss of daily waged employment`,
         c_1_6_econ_hardship_hourly_employment_reduced = `c_1_6  Reduced hours of employment, or reduced days of waged employment`,
         c_1_7_econ_hardship_other_cash_sources_reduced = `c_1_7_Reduced cash from any other sources, such as family members outside the household or government cash transfer programs`,
         c_1_8_econ_hardship_unable_tolook_employment = `c_1_8_Unable to look for employment, such as going to a town for seasonal labor`,
         
         c_2_hh_size_change = `c_2  Since the beginning of the coronavirus outbreak, has there been a change in the number of people sleeping in your household?`,
         c_2_1_hhsize_more_workerreturned_pandemic = `c_2_1_1_Somebody working elsewhere returned home because of the coronavirus outbreak`,
         c_2_2_hhsize_more_workerreturned_planned = `c_2_1_2_Somebody working elsewhere returned home, as was already planned`,
         c_2_3_hhsize_more_studentreturned_pandemic = `c_2_1_3_Somebody studying elsewhere returned home because of the coronavirus outbreak`,
         c_2_4_hhsize_more_studentreturned_planned = `c_2_1_4_ Somebody studying elsewhere returned home, as was already planned`,
         c_2_5_hhsize_more_other = `c_2_1_other specify`,
         c_2_1_hhsize_less_workerleft_pandemic = `c_2_2_1_Somebody that was living at home left to go work elsewhere, due to the coronavirus pandemic`,
         c_2_2_hhsize_less_workerleft_planned = `c_2_2_2_Somebody that was living at home left to go work elsewhere, as was already planned`,
         c_2_3_hhsize_less_studentleft_pandemic = `c_2_2_3_ Somebody that was living at home left to go study elsewhere, due to the coronavirus pandemic`,
         c_2_4_hhsize_less_studentleft_planned = `c_2_2_4_Somebody that was living at home left to go study elsewhere, as was already planned`,
         c_2_5_hhsize_less_other = `c_2_2_other specify`,
         
         c_3_lockdown_ago_weeks = `c_3 How long ago did your block experience orders to restrict time outdoors due to covid-19? _____ [weeks]`,
         c_4_change_lockdown_since = `c_4  Has there been a change in orders to restrict time outdoors in your area since then?`,
         
         d_0_1_primary_lighting_fourdays = `d_0_1  In the last four days, what has been the primary source of lighting in your household?`,
         d_0_1_primary_lighting_other = `d_0_1_other specify`,
         
         d_0_all_lighting_grid = `d_0_1   Grid electricity`,
         d_0_all_lighting_kerosene = `d_0_2  Kerosene lamp/lantern`,
         d_0_all_lighting_microgrid = `d_0_3  Micro-grid`,
         d_0_all_lighting_solar = `d_0_4   Solar home system or solar lantern`,
         d_0_all_lighting_other = `d_0_other specify`,
         
         d_0_2_has_kerosene = `d_0_2  Does your household have kerosene lamps for lighting?`,
         d_0_2_1_1_not_used_kerosene_nofuel = `d_0_2_1_1  No kerosene fuel in the household`,
         d_0_2_1_2_not_used_kerosene_conservingfuel = `d_0_2_1_2  Running low on kerosene fuel in the household and saving it`,
         d_0_2_1_3_not_used_kerosene_unablebuy = `d_0_2_1_3   Unable to purchase kerosene from ration shop or usual place of purchase`,
         d_0_2_1_4_not_used_kerosene_notgoodlight = `d_0_2_1_4  Kerosene is not a good source of light`,
         d_0_2_1_5_not_used_kerosene_unsafe = `d_0_2_1_5  Kerosene is not safe`,
         d_0_2_1_6_not_used_kerosene_hasbetter = `d_0_2_1_6  No need because we have better forms of lighting`,
         d_0_2_1_7_not_used_kerosene_broken = `d_0_2_1_7   Kerosene lamps are broken`,
         d_0_2_1_8_not_used_kerosene_other = `d_0_2_1_other specify`,
         
         d_0_3_1_kerosene_use_compare = `d_0_3_1  Thinking back to before the lockdown, are you now using kerosene for lighting more, the same, or less than before? [Note to surveyor: Do not read options unless clarification needed]`,
         d_0_3_2_kerosene_use_compare_hours = `d_0_3_2  Thinking back to during the lockdown, in comparison to before lockdown, did you use kerosene for lighting for the same number of hours, for more hours, or for fewer hours? [do not read options unless clarification needed]`,
         d_0_3_4_kerosene_use_hours = `d_0_3_4  n the last four days, in a typical day, how many hours a day did you have at least one kerosene lamp on for lighting? [NUMBER OF HOURS DURING WHICH AT LEAST ONE LAMP IS ON] ______________ [HOURS/DAY]`,
         
         d_2_primary_cook_fuel = `d_2  In the last four days, what has been your primary cooking fuel?`,
         d_2_primary_cook_fuel_other = `d_2_other specify`,
         
         d_1_1_firewood = `d_1_1  Firewood and chips`,
         d_1_2_any_cook_fuel_agresidue = `d_1_2  Agricultural or crop residue`,
         d_1_3_any_cook_fuel_dung = `d_1_3  Animal waste / dung cakes`,
         d_1_4_any_cook_fuel_charcoal = `d_1_4  Charcoal`,
         d_1_5_any_cook_fuel_coal = `d_1_5  Coal`,
         d_1_6_any_cook_fuel_kerosene = `d_1_6  Kerosene / paraffin`,
         d_1_7_any_cook_fuel_alcohol = `d_1_7   Alcohol / ethanol`,
         d_1_8_any_cook_fuel_gasoline = `d_1_8  Gasoline / diesel (not in generator)`,
         d_1_9_any_cook_fuel_lpg = `d_1_9  Liquefied petroleum gas (LPG)`,
         d_1_10_any_cook_fuel_biogas = `d_1_10  Bio-gas`,
         d_1_11_any_cook_fuel_electricity = `d_1_11   Electricity`,
         d_1_12_any_cook_fuel_other = `d_1_other specify`,
         
         d_3_has_lpg = `d_3  Does your household have an LPG connection?`,
         d_3_1_1_not_used_lpg_nofuel =`d_3_1_1  No LPG fuel in the household`,
         d_3_1_2_not_used_lpg_conservingfuel =`d_3_1_2  Running low on LPG fuel in the household and saving it`,
         d_3_1_3_not_used_lpg_notcookusualdishes =`d_3_1_3  The households has not cooked the usual dishes that the LPG stove is used for`,
         d_3_1_4_not_used_lpg_otherfuels =`d_3_1_4  The household has lots of other fuels that we are using instead`,
         d_3_1_5_not_used_lpg_notlikenow =`d_3_1_5   We do not like to use the LPG stove these days`,
         d_3_1_6_not_used_lpg_fearful =`d_3_1_6  Fear of using the LPG stove`,
         d_3_1_7_not_used_lpg_usualcookisnotcook =`d_3_1_7   The person that normally cooks using LPG has not been cooking`,
         d_3_1_8_not_used_lpg_broken = `d_3_1_8  The LPG stove is broken and cannot be used`,
         d_3_1_9_not_used_lpg_other = `d_3_1_other specify`,
         
         d_4_lpg_via_pmuy = `d_4  Did you receive the LPG connection under Pradhan Mantri Ujjwala Yojana (PMUY)?`,
         d_5_multiple_cylinders = `d_5  Do you have more than one gas cylinder in your household?`,
         d_5_1_multiple_cylinders_sizes = `d_5_1  What size are the LPG cylinders you currently have?`,
         d_5_2_one_cylinder_size = `d_5_2_What size is the LPG cylinder you currently have?`,
         d_5_3_singleordouble_connection = `d_5_3_Do you have a single or double bottle connection from your LPG provider (LPG Agency)?`,
         d_5_4_second_cylinder_source = `d_5_4_If single bottle connection, so from whom did you take the second LPG cylinder?`,
         
         d_6_fourdays_typical_number_meals = `d_6  In the last four days, during a typical day, about how many meals have been cooked in your house? (Note to interviewer: this question seeks to estimate the average number of meals cooked per day -- not a sum over the past four days) _________ [# meals per day]`,
         d_7_fourdays_hours_cook = `d_7  In the last four days, during a typical day, how much time is spent cooking? _________ [# hours per day]All meals combined — total number of hours cooking / stove on in the entire day`,
         d_8_1_cook_hours_compare_inlockdown = `d_8_1  Thinking back to before the lockdown, are you now cooking in total for more hours, for the same number of hours, or for fewer hours as compared to before?`,
         d_8_2_cook_hours_compare_recalllockdown = `d_8_2  During the lockdown, in comparison with before the lockdown, did you cook for more hours, for the same number of hours, or for fewer hours overall? [do not read options unless clarification needed]`,
         
         d_9_lpg_use_compare = `d_9  Compared to before lockdown, how are you using LPG? If something has changed, please tell us. [READ OPTIONS]`,
         d_10_pollutingfuel_use_compare = `d_10  Thinking back to before the lockdown, how would you describe your use of the traditional fuels like firewood, coal, dung, agricultural residues, and kerosene now? [READ OPTIONS]`,
         
         e_1_1_refill_lpg_inlockdown = `e_1_1  Since the lockdown began, have you refilled your LPG cylinder?`,
         e_1_2_refill_lpg_recalllockdown = `e_1_2 During the period of the lockdown, did you refill your LPG cylinder?`,
         
         e_2_refill_lpg_wksago = `e_2  How many weeks ago did you last refill your large LPG cylinder? ______ [# weeks]`,
         e_3_refill_source = `e_3  Where did you get that refill from?`,
         e_3_refill_source_other = `e_3_other specify`,
         e_4_1_refill_differences_nodelivery = `e_4_1 No delivery as compared to usual delivery`,
         e_4_2_refill_differences_deliverynow = `e_4_2  Delivery as compared to not usually getting delivery`,
         e_4_3_refill_differences_longerwait = `e_4_3   Longer wait as compared to usual at distributor shop`,
         e_4_4_refill_differences_shorterwait = `e_4_4  Shorter wait as compared to usual at distributor shop`,
         e_4_5_refill_differences_pickupfurther = `e_4_5  Village pick-up point was further away than usual`,
         e_4_6_refill_differences_pickupcloser = `e_4_6  Village pick-up point was closer than usual`,
         e_4_7_refill_differences_none = `e_4_7_There were no differences`,
         e_4_8_refill_differences_other = `e_4_other specify`,
         
         e_5_subsidy_time_compare = `e_5  Thinking back to before the lockdown, does it take less time, more time, or the same amount of time to receive the subsidy amount in your bank account?`,
         e_6_lpgrefill_cost = `e_6  How much did you pay at the time of purchase for your last LPG cylinder? ______ [INR]`,
         e_7_1_nolpg_refill_didnotrunout = `e_7_1  Did not run out of gas`,
         e_7_2_nolpg_refill_rationed = `e_7_2  Rationed gas so I did not run out`,
         e_7_3_nolpg_refill_nomoney = `e_7_3   Did not have money available`,
         e_7_4_nolpg_refill_didnotwanttoleave = `e_7_4  Did not want to leave household to get refill`,
         e_7_5_nolpg_refill_deliveryunavailable = `e_7_5  Normal gas delivery not available`,
         e_7_6_nolpg_refill_couldnotleave = `e_7_6 Was not allowed to leave household to get refill`,
         e_7_7_nolpg_refill_other = `e_7_other specify`,
         
         e_8_refill_next_wks = `e_8  When do you expect to next refill an LPG cylinder? ______ [# weeks]`,
         
         f_1_firewood_compare_collect_freq_inlockdown = `f_1 As compared to before the lockdown, has your household been collecting firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_2_firewood_compare_collect_amt_inlockdown = `f_2 As compared to before the lockdown, has your household collected more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         # f_3_firewood_compare_reserve_amt_inlockdown = `f_3 As compared to before the lockdown, does the household now have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically? [Note for surveyor: This question refers to the amount/volume/weight of fuel being stored in the household. Households often have some amount of fuel being stored that they then are able to use for cooking at any given point. Here, we ask if they have approximately the same, more, or less fuel stored in the household as compared to before.]`,
         f_4_firewood_compare_collect_difficulty_inlockdown = `f_4  As compared to before the lockdown, does the household now have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_5_firewood_compare_collect_freq_recalllockdown = `f_5  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_6_firewood_compare_collect_amt_recalllockdown = `f_6  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         f_7_firewood_compare_reserve_amt_recalllockdown = `f_7  Thinking back to during the lockdown, in comparison with before the lockdown, did your household have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically?`,
         f_8_firewood_compare_collect_amt_recalllockdown = `f_8  Thinking back to during the lockdown, as compared to non-lockdown times, did your household have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_9_firewood_collect_last_days = `f_9  When was the last time a household member collected firewood, twigs, agricultural residues, or dung cakes? ______ [days ago]`,
         f_10_firewood_collect_next_days = `f_10  When do you expect that a household member will next go for collecting firewood, twigs, agricultural residues, or dung cakes? ______ [days from now]`,
         
         f_11_coal_compare_collect_freq_inlockdown = `f_11  As compared to before the lockdown, has your household been collecting coal more, the same, or less frequently than before?`,
         f_12_coal_compare_collect_amt_inlockdown = `f_12  As compared to before the lockdown, has your household been collecting coal more, the same, or less in a typical trip than before?`,
         f_13_coal_collect_location_inlockdown = `f_13  Where have you gone to get coal during lockdown?`,
         f_13_1_1_nocoal_havefuel = `f_13_1_1  I have not run out of coal`,
         f_13_1_2_nocoal_notusing = `f_13_1_2  I have not been using coal for cooking during lockdown`,
         f_13_1_3_nocoal_nomoney = `f_13_1_3  Did not have money available`,
         f_13_1_4_nocoal_didnotwanttoleave = `f_13_1_4  Did not want to leave household to get coal`,
         f_13_1_5_nocoal_normalspotunavailable = `f_13_1_5   Normal coal buying location not available`,
         f_13_1_6_nocoal_cantleave = `f_13_1_6  Was not allowed to leave household to get coal`,
         f_13_1_7_nocoal_other = `f_13_1_other specify`,
         
         f_14_coal_compare_collect_freq_recalllockdown = `f_14  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect coal more, the same, or less frequently than before?`,
         f_15_coal_compare_collect_amt_recalllockdown = `f_15  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect the same, or less in a typical trip than before?`,
         f_16_coal_compare_collect_location_recalllockdown = `f_16  Thinking back to during the lockdown, where did you go to get coal?`,
         
         g_1_lpg_refill_cost_compare_inlockdown = `g_1_1  Since the lockdown has begun, how does the price of an LPG cylinder refill compare to before?`,
         g_1_lpg_refill_cost_compare_reaclllockdown = `g_1_2   Thinking back to during the lockdown, in comparison with before the lockdown, how did the price of an LPG cylinder refill compare to before?`,
         g_2_lpg_refill_difficulty_inlockdown = `g_2  Since the lockdown began, is it now easier, more difficult, or the same difficulty of acquiring an LPG cylinder refill?`,
         g_3_1_like_using_lpg_more = `g_3  Do you agree or disagree with the following statement: Since the lockdown has begun, we like to cook with gas more than before.`,
         g_3_1_1_like_using_lpg_more_valuefastcooking = `g_3_1_1  We value faster cooking with LPG more now during lockdown`,
         g_3_1_2_like_using_lpg_more_cheapernow = `g_3_1_2   LPG is cheaper now`,
         g_3_1_3_like_using_lpg_more_accessiblenow = `g_3_1_3   LPG is more accessible now`,
         g_3_1_4_like_using_lpg_more_threecylpolicy = `g_3_1_4   Three free cylinder policy`,
         g_3_1_5_like_using_lpg_more_lessbiomassnow= `g_3_1_5  Household has less biomass now`,
         g_3_1_6_like_using_lpg_more_biomassacquireharder = `g_3_1_6   Household can acquire biomass less easily now`,
         g_3_1_7_like_using_lpg_more_tastepreferenceforlpg = `g_3_1_7  Household preferences favor the taste of food cooked with LPG`,
         g_3_1_8_like_using_lpg_more_tastepreferenceawayfirewood = `g_3_1_8  Household preferences shifting away from the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_1_9_like_using_lpg_more_prefercooklpg = `g_3_1_9  Household preferences favor the experience of cooking with LPG`,
         g_3_1_10_like_using_lpg_more_awaycookfirewood = `g_3_1_10  Household preferences shifting away the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_1_11_like_using_lpg_more_other = `g_3_1_other specify`,
         
         g_3_2_1_like_using_lpg_less_morecostly = `g_3_2_1   LPG is more expensive now`,
         g_3_2_2_like_using_lpg_less_lessaccessible = `g_3_2_2   LPG is less accessible now`,
         g_3_2_3_like_using_lpg_less_morebiomassnow = `g_3_2_3  Household has more biomass now`,
         g_3_2_4_like_using_lpg_less_tastepreferenceforfirewood = `g_3_2_4  Household preferences favor the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_2_5_like_using_lpg_less_tastepreferenceawaylpg = `g_3_2_5  Household does not prefer the taste of food cooked with LPG`,
         g_3_2_6_like_using_lpg_less_prefercookfirewood = `g_3_2_6 Household preferences favor the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_2_7_like_using_lpg_less_awaycooklpg = `g_3_2_7  Household does not prefer the experience of cooking with LPG`,
         g_3_2_8_like_using_lpg_less_other = `g_3_2_other specify`,
         
         h_1_threecylinder_aware = `h_1   As of April 1, 2020, the Government of India has made three free LPG cylinder refills available to Ujjwala beneficiaries. Prior to our conversation, were you or anybody in this household aware of this policy?`,
         h_2_threecylinder_aware_how = `h_2   How did you or anybody in the household become aware of this program/policy?`,
         h_2_threecylinder_aware_how_other = `h_2_other specify`,
         h_3_lpg_refill_subsidy_deposited = `h_3  Have you received an LPG refill subsidy deposited into your bank account?`,
         h_4_obtained_free_cylinder = `h_4  Have you obtained or received any of these three free cylinders?`,
         h_4_1_obtained_free_cylinder_number = `h_4_1  How many such free refills have you received? ______ [# refills; MAXIMUM NUMERIC VALUE OF 5]`,
         h_4_2_free_cylinder_process_convenience = `h_4_2  Did you find the process as convenient as acquiring a typical refill?`,
         h_4_2_1_process_difficult_fullpriceatsale = `h_4_2_1_1   Having to pay the full price at the time of sale is difficult`,
         h_4_2_2_process_difficult_longgetsubsidy = `h_4_2_1_2   It took longer to receive the subsidy/stimulus in the bank account`,
         h_4_2_2_process_difficult_moredifficultrefill = `h_4_2_1_3  It was more difficult to get to where I refilled the cylinder as compared to before due to travel restrictions`,
         h_4_2_2_process_difficult_policyconfusionatsale = `h_4_2_1_4  There was confusion about the policy at the point of sale`,
         h_4_2_2_process_difficult_other = `h_4_2_1_other specify`,
         h_5_threecylinder_use_future = `h_5   Do you plan to take advantage of the program in the future?`,
         h_6_threecylinder_use_future = `h_6   Do you plan to take advantage of the program in the future?`,
         
         i_1_covid_threatlevel = `i_1  What level of threat do you think COVID-19 poses to you or your family?`,
         i_2_covid_followguidelines = `i_2  In general, to what extent are people in your village following government guidelines about physical distancing and lockdown?`,
         i_3_covid_firewood_increaserisk = `i_3   Do you agree or disagree with the following statement: Cooking with firewood increases risk of COVID-related serious illness or death?`,
         i_4_1_covid_lpg_reducerisk_choice = `i_4_1 If medical research finds that LPG use reduces risk of COVID related serious illness, what would best describe your situation regarding LPG use and other fuels as applicable in the future for household needs?`,
         i_4_1_covid_firewood_increaserisk_choice = `i_4_2 Suppose that medical experts find that using LPG more, and the Chula less, reduces risk of getting very sick from COVID. What would best describe your future plans for acquiring and then using LPG?`,
         
  ) %>% 
  na_if(-99) %>% 
  mutate(date_interview = ymd(convertToDate(date_interview)),
         start_time_interview = ymd_hms(convertToDateTime(start_time_interview)),
         end_time_interview = ymd_hms(convertToDateTime(end_time_interview)))

colnames(jcovid4_1)[152] <- "f_3_firewood_compare_reserve_amt_inlockdown" 


# Round 5 -------
jcovid5_1 <- jcovid5 %>%
  rename(hhid = `hh_id_ Household ID_Baseline IDs`,
         age = `age_What is your age? _________ [years]`,
         age1 = `age_1_What is your age? _________ [years]`,
         date_interview = `date_int_Date of Interview`,
         start_time_interview = `start`,
         end_time_interview = `end`,
         
         b_1_relation_to_hhead = `q_b_1  What is your relationship to the household head?`,
         b_2_is_primary_cook = `q_b_2  Are you the primary cook for the household?`,
         b_3_gender = `q_b_3  What is your gender?`,
         
         c_1_1_econ_hardship_difficulty_food = `c_1_1  In the past 7 days, has your family endured any of the following economic hardships due to COVID-19? [ASK ALL QUESTIONS]_Increased difficulty accessing food for the household\r\n`,
         c_1_2_econ_hardship_increase_prices = `c_1_2  Increased prices for necessary goods`,
         c_1_3_econ_hardship_reduced_income = `c_1_3 Reduced income from any form of economic activity`,
         c_1_4_econ_hardship_salary_employment_loss = `c_1_4  Loss of salaried employment`,
         c_1_5_econ_hardship_hourly_employment_loss = `c_1_5  Loss of hourly waged employment, or loss of daily waged employment`,
         c_1_6_econ_hardship_hourly_employment_reduced = `c_1_6  Reduced hours of employment, or reduced days of waged employment`,
         c_1_7_econ_hardship_other_cash_sources_reduced = `c_1_7_Reduced cash from any other sources, such as family members outside the household or government cash transfer programs`,
         c_1_8_econ_hardship_unable_tolook_employment = `c_1_8_Unable to look for employment, such as going to a town for seasonal labor`,
         
         c_2_hh_size_change = `c_2  Since the beginning of the coronavirus outbreak, has there been a change in the number of people sleeping in your household?`,
         c_2_1_hhsize_more_workerreturned_pandemic = `c_2_1_1_Somebody working elsewhere returned home because of the coronavirus outbreak`,
         c_2_2_hhsize_more_workerreturned_planned = `c_2_1_2_Somebody working elsewhere returned home, as was already planned`,
         c_2_3_hhsize_more_studentreturned_pandemic = `c_2_1_3_Somebody studying elsewhere returned home because of the coronavirus outbreak`,
         c_2_4_hhsize_more_studentreturned_planned = `c_2_1_4_ Somebody studying elsewhere returned home, as was already planned`,
         c_2_5_hhsize_more_other = `c_2_1_other specify`,
         c_2_1_hhsize_less_workerleft_pandemic = `c_2_2_1_Somebody that was living at home left to go work elsewhere, due to the coronavirus pandemic`,
         c_2_2_hhsize_less_workerleft_planned = `c_2_2_2_Somebody that was living at home left to go work elsewhere, as was already planned`,
         c_2_3_hhsize_less_studentleft_pandemic = `c_2_2_3_ Somebody that was living at home left to go study elsewhere, due to the coronavirus pandemic`,
         c_2_4_hhsize_less_studentleft_planned = `c_2_2_4_Somebody that was living at home left to go study elsewhere, as was already planned`,
         c_2_5_hhsize_less_other = `c_2_2_other specify`,
         
         c_3_lockdown_ago_weeks = `c_3 How long ago did your block experience orders to restrict time outdoors due to covid-19? _____ [weeks]`,
         c_4_change_lockdown_since = `c_4  Has there been a change in orders to restrict time outdoors in your area since then?`,
         
         d_0_1_primary_lighting_fourdays = `d_0_1  In the last four days, what has been the primary source of lighting in your household?`,
         d_0_1_primary_lighting_other = `d_0_1_other specify`,
         
         d_0_all_lighting_grid = `d_0_1   Grid electricity`,
         d_0_all_lighting_kerosene = `d_0_2  Kerosene lamp/lantern`,
         d_0_all_lighting_microgrid = `d_0_3  Micro-grid`,
         d_0_all_lighting_solar = `d_0_4   Solar home system or solar lantern`,
         d_0_all_lighting_other = `d_0_other specify`,
         
         d_0_2_has_kerosene = `d_0_2  Does your household have kerosene lamps for lighting?`,
         d_0_2_1_1_not_used_kerosene_nofuel = `d_0_2_1_1  No kerosene fuel in the household`,
         d_0_2_1_2_not_used_kerosene_conservingfuel = `d_0_2_1_2  Running low on kerosene fuel in the household and saving it`,
         d_0_2_1_3_not_used_kerosene_unablebuy = `d_0_2_1_3   Unable to purchase kerosene from ration shop or usual place of purchase`,
         d_0_2_1_4_not_used_kerosene_notgoodlight = `d_0_2_1_4  Kerosene is not a good source of light`,
         d_0_2_1_5_not_used_kerosene_unsafe = `d_0_2_1_5  Kerosene is not safe`,
         d_0_2_1_6_not_used_kerosene_hasbetter = `d_0_2_1_6  No need because we have better forms of lighting`,
         d_0_2_1_7_not_used_kerosene_broken = `d_0_2_1_7   Kerosene lamps are broken`,
         d_0_2_1_8_not_used_kerosene_other = `d_0_2_1_other specify`,
         
         d_0_3_1_kerosene_use_compare = `d_0_3_1  Thinking back to before the lockdown, are you now using kerosene for lighting more, the same, or less than before? [Note to surveyor: Do not read options unless clarification needed]`,
         d_0_3_2_kerosene_use_compare_hours = `d_0_3_2  Thinking back to during the lockdown, in comparison to before lockdown, did you use kerosene for lighting for the same number of hours, for more hours, or for fewer hours? [do not read options unless clarification needed]`,
         d_0_3_4_kerosene_use_hours = `d_0_3_4  n the last four days, in a typical day, how many hours a day did you have at least one kerosene lamp on for lighting? [NUMBER OF HOURS DURING WHICH AT LEAST ONE LAMP IS ON] ______________ [HOURS/DAY]`,
         
         d_2_primary_cook_fuel = `d_2  In the last four days, what has been your primary cooking fuel?`,
         d_2_primary_cook_fuel_other = `d_2_other specify`,
         
         d_1_1_firewood = `d_1_1  Firewood and chips`,
         d_1_2_any_cook_fuel_agresidue = `d_1_2  Agricultural or crop residue`,
         d_1_3_any_cook_fuel_dung = `d_1_3  Animal waste / dung cakes`,
         d_1_4_any_cook_fuel_charcoal = `d_1_4  Charcoal`,
         d_1_5_any_cook_fuel_coal = `d_1_5  Coal`,
         d_1_6_any_cook_fuel_kerosene = `d_1_6  Kerosene / paraffin`,
         d_1_7_any_cook_fuel_alcohol = `d_1_7   Alcohol / ethanol`,
         d_1_8_any_cook_fuel_gasoline = `d_1_8  Gasoline / diesel (not in generator)`,
         d_1_9_any_cook_fuel_lpg = `d_1_9  Liquefied petroleum gas (LPG)`,
         d_1_10_any_cook_fuel_biogas = `d_1_10  Bio-gas`,
         d_1_11_any_cook_fuel_electricity = `d_1_11   Electricity`,
         d_1_12_any_cook_fuel_other = `d_1_other specify`,
         
         d_3_has_lpg = `d_3  Does your household have an LPG connection?`,
         d_3_1_1_not_used_lpg_nofuel =`d_3_1_1  No LPG fuel in the household`,
         d_3_1_2_not_used_lpg_conservingfuel =`d_3_1_2  Running low on LPG fuel in the household and saving it`,
         d_3_1_3_not_used_lpg_notcookusualdishes =`d_3_1_3  The households has not cooked the usual dishes that the LPG stove is used for`,
         d_3_1_4_not_used_lpg_otherfuels =`d_3_1_4  The household has lots of other fuels that we are using instead`,
         d_3_1_5_not_used_lpg_notlikenow =`d_3_1_5   We do not like to use the LPG stove these days`,
         d_3_1_6_not_used_lpg_fearful =`d_3_1_6  Fear of using the LPG stove`,
         d_3_1_7_not_used_lpg_usualcookisnotcook =`d_3_1_7   The person that normally cooks using LPG has not been cooking`,
         d_3_1_8_not_used_lpg_broken = `d_3_1_8  The LPG stove is broken and cannot be used`,
         d_3_1_9_not_used_lpg_other = `d_3_1_other specify`,
         
         d_4_lpg_via_pmuy = `d_4  Did you receive the LPG connection under Pradhan Mantri Ujjwala Yojana (PMUY)?`,
         d_5_multiple_cylinders = `d_5  Do you have more than one gas cylinder in your household?`,
         d_5_1_multiple_cylinders_sizes = `d_5_1  What size are the LPG cylinders you currently have?`,
         d_5_2_one_cylinder_size = `d_5_2_What size is the LPG cylinder you currently have?`,
         d_5_3_singleordouble_connection = `d_5_3_Do you have a single or double bottle connection from your LPG provider (LPG Agency)?`,
         d_5_4_second_cylinder_source = `d_5_4_If single bottle connection, so from whom did you take the second LPG cylinder?`,
         
         d_6_fourdays_typical_number_meals = `d_6  In the last four days, during a typical day, about how many meals have been cooked in your house? (Note to interviewer: this question seeks to estimate the average number of meals cooked per day -- not a sum over the past four days) _________ [# meals per day]`,
         d_7_fourdays_hours_cook = `d_7  In the last four days, during a typical day, how much time is spent cooking? _________ [# hours per day]All meals combined — total number of hours cooking / stove on in the entire day`,
         d_8_1_cook_hours_compare_inlockdown = `d_8_1  Thinking back to before the lockdown, are you now cooking in total for more hours, for the same number of hours, or for fewer hours as compared to before?`,
         d_8_2_cook_hours_compare_recalllockdown = `d_8_2  During the lockdown, in comparison with before the lockdown, did you cook for more hours, for the same number of hours, or for fewer hours overall? [do not read options unless clarification needed]`,
         
         d_9_lpg_use_compare = `d_9  Compared to before lockdown, how are you using LPG? If something has changed, please tell us. [READ OPTIONS]`,
         d_10_pollutingfuel_use_compare = `d_10  Thinking back to before the lockdown, how would you describe your use of the traditional fuels like firewood, coal, dung, agricultural residues, and kerosene now? [READ OPTIONS]`,
         
         e_1_1_refill_lpg_inlockdown = `e_1_1  Since the lockdown began, have you refilled your LPG cylinder?`,
         e_1_2_refill_lpg_recalllockdown = `e_1_2 During the period of the lockdown, did you refill your LPG cylinder?`,
         
         e_2_refill_lpg_wksago = `e_2  How many weeks ago did you last refill your large LPG cylinder? ______ [# weeks]`,
         e_3_refill_source = `e_3  Where did you get that refill from?`,
         e_3_refill_source_other = `e_3_other specify`,
         e_4_1_refill_differences_nodelivery = `e_4_1 No delivery as compared to usual delivery`,
         e_4_2_refill_differences_deliverynow = `e_4_2  Delivery as compared to not usually getting delivery`,
         e_4_3_refill_differences_longerwait = `e_4_3   Longer wait as compared to usual at distributor shop`,
         e_4_4_refill_differences_shorterwait = `e_4_4  Shorter wait as compared to usual at distributor shop`,
         e_4_5_refill_differences_pickupfurther = `e_4_5  Village pick-up point was further away than usual`,
         e_4_6_refill_differences_pickupcloser = `e_4_6  Village pick-up point was closer than usual`,
         e_4_7_refill_differences_none = `e_4_7_There were no differences`,
         e_4_8_refill_differences_other = `e_4_other specify`,
         
         e_5_subsidy_time_compare = `e_5  Thinking back to before the lockdown, does it take less time, more time, or the same amount of time to receive the subsidy amount in your bank account?`,
         e_6_lpgrefill_cost = `e_6  How much did you pay at the time of purchase for your last LPG cylinder? ______ [INR]`,
         e_7_1_nolpg_refill_didnotrunout = `e_7_1  Did not run out of gas`,
         e_7_2_nolpg_refill_rationed = `e_7_2  Rationed gas so I did not run out`,
         e_7_3_nolpg_refill_nomoney = `e_7_3   Did not have money available`,
         e_7_4_nolpg_refill_didnotwanttoleave = `e_7_4  Did not want to leave household to get refill`,
         e_7_5_nolpg_refill_deliveryunavailable = `e_7_5  Normal gas delivery not available`,
         e_7_6_nolpg_refill_couldnotleave = `e_7_6 Was not allowed to leave household to get refill`,
         e_7_7_nolpg_refill_other = `e_7_other specify`,
         
         e_8_refill_next_wks = `e_8  When do you expect to next refill an LPG cylinder? ______ [# weeks]`,
         
         f_1_firewood_compare_collect_freq_inlockdown = `f_1 As compared to before the lockdown, has your household been collecting firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_2_firewood_compare_collect_amt_inlockdown = `f_2 As compared to before the lockdown, has your household collected more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         # f_3_firewood_compare_reserve_amt_inlockdown = `f_3 As compared to before the lockdown, does the household now have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically? [Note for surveyor: This question refers to the amount/volume/weight of fuel being stored in the household. Households often have some amount of fuel being stored that they then are able to use for cooking at any given point. Here, we ask if they have approximately the same, more, or less fuel stored in the household as compared to before.]`,
         f_4_firewood_compare_collect_difficulty_inlockdown = `f_4  As compared to before the lockdown, does the household now have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_5_firewood_compare_collect_freq_recalllockdown = `f_5  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_6_firewood_compare_collect_amt_recalllockdown = `f_6  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         f_7_firewood_compare_reserve_amt_recalllockdown = `f_7  Thinking back to during the lockdown, in comparison with before the lockdown, did your household have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically?`,
         f_8_firewood_compare_collect_amt_recalllockdown = `f_8  Thinking back to during the lockdown, as compared to non-lockdown times, did your household have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_9_firewood_collect_last_days = `f_9  When was the last time a household member collected firewood, twigs, agricultural residues, or dung cakes? ______ [days ago]`,
         f_10_firewood_collect_next_days = `f_10  When do you expect that a household member will next go for collecting firewood, twigs, agricultural residues, or dung cakes? ______ [days from now]`,
         
         f_11_coal_compare_collect_freq_inlockdown = `f_11  As compared to before the lockdown, has your household been collecting coal more, the same, or less frequently than before?`,
         f_12_coal_compare_collect_amt_inlockdown = `f_12  As compared to before the lockdown, has your household been collecting coal more, the same, or less in a typical trip than before?`,
         f_13_coal_collect_location_inlockdown = `f_13  Where have you gone to get coal during lockdown?`,
         f_13_1_1_nocoal_havefuel = `f_13_1_1  I have not run out of coal`,
         f_13_1_2_nocoal_notusing = `f_13_1_2  I have not been using coal for cooking during lockdown`,
         f_13_1_3_nocoal_nomoney = `f_13_1_3  Did not have money available`,
         f_13_1_4_nocoal_didnotwanttoleave = `f_13_1_4  Did not want to leave household to get coal`,
         f_13_1_5_nocoal_normalspotunavailable = `f_13_1_5   Normal coal buying location not available`,
         f_13_1_6_nocoal_cantleave = `f_13_1_6  Was not allowed to leave household to get coal`,
         f_13_1_7_nocoal_other = `f_13_1_other specify`,
         
         f_14_coal_compare_collect_freq_recalllockdown = `f_14  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect coal more, the same, or less frequently than before?`,
         f_15_coal_compare_collect_amt_recalllockdown = `f_15  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect the same, or less in a typical trip than before?`,
         f_16_coal_compare_collect_location_recalllockdown = `f_16  Thinking back to during the lockdown, where did you go to get coal?`,
         
         g_1_lpg_refill_cost_compare_inlockdown = `g_1_1  Since the lockdown has begun, how does the price of an LPG cylinder refill compare to before?`,
         g_1_lpg_refill_cost_compare_reaclllockdown = `g_1_2   Thinking back to during the lockdown, in comparison with before the lockdown, how did the price of an LPG cylinder refill compare to before?`,
         g_2_lpg_refill_difficulty_inlockdown = `g_2  Since the lockdown began, is it now easier, more difficult, or the same difficulty of acquiring an LPG cylinder refill?`,
         g_3_1_like_using_lpg_more = `g_3  Do you agree or disagree with the following statement: Since the lockdown has begun, we like to cook with gas more than before.`,
         g_3_1_1_like_using_lpg_more_valuefastcooking = `g_3_1_1  We value faster cooking with LPG more now during lockdown`,
         g_3_1_2_like_using_lpg_more_cheapernow = `g_3_1_2   LPG is cheaper now`,
         g_3_1_3_like_using_lpg_more_accessiblenow = `g_3_1_3   LPG is more accessible now`,
         g_3_1_4_like_using_lpg_more_threecylpolicy = `g_3_1_4   Three free cylinder policy`,
         g_3_1_5_like_using_lpg_more_lessbiomassnow= `g_3_1_5  Household has less biomass now`,
         g_3_1_6_like_using_lpg_more_biomassacquireharder = `g_3_1_6   Household can acquire biomass less easily now`,
         g_3_1_7_like_using_lpg_more_tastepreferenceforlpg = `g_3_1_7  Household preferences favor the taste of food cooked with LPG`,
         g_3_1_8_like_using_lpg_more_tastepreferenceawayfirewood = `g_3_1_8  Household preferences shifting away from the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_1_9_like_using_lpg_more_prefercooklpg = `g_3_1_9  Household preferences favor the experience of cooking with LPG`,
         g_3_1_10_like_using_lpg_more_awaycookfirewood = `g_3_1_10  Household preferences shifting away the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_1_11_like_using_lpg_more_other = `g_3_1_other specify`,
         
         g_3_2_1_like_using_lpg_less_morecostly = `g_3_2_1   LPG is more expensive now`,
         g_3_2_2_like_using_lpg_less_lessaccessible = `g_3_2_2   LPG is less accessible now`,
         g_3_2_3_like_using_lpg_less_morebiomassnow = `g_3_2_3  Household has more biomass now`,
         g_3_2_4_like_using_lpg_less_tastepreferenceforfirewood = `g_3_2_4  Household preferences favor the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_2_5_like_using_lpg_less_tastepreferenceawaylpg = `g_3_2_5  Household does not prefer the taste of food cooked with LPG`,
         g_3_2_6_like_using_lpg_less_prefercookfirewood = `g_3_2_6 Household preferences favor the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_2_7_like_using_lpg_less_awaycooklpg = `g_3_2_7  Household does not prefer the experience of cooking with LPG`,
         g_3_2_8_like_using_lpg_less_other = `g_3_2_other specify`,
         
         h_1_threecylinder_aware = `h_1   As of April 1, 2020, the Government of India has made three free LPG cylinder refills available to Ujjwala beneficiaries. Prior to our conversation, were you or anybody in this household aware of this policy?`,
         h_2_threecylinder_aware_how = `h_2   How did you or anybody in the household become aware of this program/policy?`,
         h_2_threecylinder_aware_how_other = `h_2_other specify`,
         h_3_lpg_refill_subsidy_deposited = `h_3  Have you received an LPG refill subsidy deposited into your bank account?`,
         h_4_obtained_free_cylinder = `h_4  Have you obtained or received any of these three free cylinders?`,
         h_4_1_obtained_free_cylinder_number = `h_4_1  How many such free refills have you received? ______ [# refills; MAXIMUM NUMERIC VALUE OF 5]`,
         h_4_2_free_cylinder_process_convenience = `h_4_2  Did you find the process as convenient as acquiring a typical refill?`,
         h_4_2_1_process_difficult_fullpriceatsale = `h_4_2_1_1   Having to pay the full price at the time of sale is difficult`,
         h_4_2_2_process_difficult_longgetsubsidy = `h_4_2_1_2   It took longer to receive the subsidy/stimulus in the bank account`,
         h_4_2_2_process_difficult_moredifficultrefill = `h_4_2_1_3  It was more difficult to get to where I refilled the cylinder as compared to before due to travel restrictions`,
         h_4_2_2_process_difficult_policyconfusionatsale = `h_4_2_1_4  There was confusion about the policy at the point of sale`,
         h_4_2_2_process_difficult_other = `h_4_2_1_other specify`,
         h_5_threecylinder_use_future = `h_5   Do you plan to take advantage of the program in the future?`,
         h_6_threecylinder_use_future = `h_6   Do you plan to take advantage of the program in the future?`,
         
         i_1_covid_threatlevel = `i_1  What level of threat do you think COVID-19 poses to you or your family?`,
         i_2_covid_followguidelines = `i_2  In general, to what extent are people in your village following government guidelines about physical distancing and lockdown?`,
         i_3_covid_firewood_increaserisk = `i_3   Do you agree or disagree with the following statement: Cooking with firewood increases risk of COVID-related serious illness or death?`,
         i_4_1_covid_lpg_reducerisk_choice = `i_4_1 If medical research finds that LPG use reduces risk of COVID related serious illness, what would best describe your situation regarding LPG use and other fuels as applicable in the future for household needs?`,
         i_4_1_covid_firewood_increaserisk_choice = `i_4_2 Suppose that medical experts find that using LPG more, and the Chula less, reduces risk of getting very sick from COVID. What would best describe your future plans for acquiring and then using LPG?`,
         
  ) %>% 
  na_if(-99) %>% 
  mutate(date_interview = ymd(convertToDate(date_interview)),
         start_time_interview = ymd_hms(convertToDateTime(start_time_interview)),
         end_time_interview = ymd_hms(convertToDateTime(end_time_interview)))

colnames(jcovid5_1)[152] <- "f_3_firewood_compare_reserve_amt_inlockdown" 


# Round 6 -------
jcovid6_1 <- jcovid6 %>%
  rename(hhid = `hh_id_ Household ID_Baseline IDs`,
         age = `age_What is your age? _________ [years]`,
         age1 = `age_1_What is your age? _________ [years]`,
         date_interview = `date_int_Date of Interview`,
         start_time_interview = `start`,
         end_time_interview = `end`,
         
         b_1_relation_to_hhead = `q_b_1  What is your relationship to the household head?`,
         b_2_is_primary_cook = `q_b_2  Are you the primary cook for the household?`,
         b_3_gender = `q_b_3  What is your gender?`,
         
         c_1_1_econ_hardship_difficulty_food = `c_1_1  In the past 7 days, has your family endured any of the following economic hardships due to COVID-19? [ASK ALL QUESTIONS]_Increased difficulty accessing food for the household\r\n`,
         c_1_2_econ_hardship_increase_prices = `c_1_2  Increased prices for necessary goods`,
         c_1_3_econ_hardship_reduced_income = `c_1_3 Reduced income from any form of economic activity`,
         c_1_4_econ_hardship_salary_employment_loss = `c_1_4  Loss of salaried employment`,
         c_1_5_econ_hardship_hourly_employment_loss = `c_1_5  Loss of hourly waged employment, or loss of daily waged employment`,
         c_1_6_econ_hardship_hourly_employment_reduced = `c_1_6  Reduced hours of employment, or reduced days of waged employment`,
         c_1_7_econ_hardship_other_cash_sources_reduced = `c_1_7_Reduced cash from any other sources, such as family members outside the household or government cash transfer programs`,
         c_1_8_econ_hardship_unable_tolook_employment = `c_1_8_Unable to look for employment, such as going to a town for seasonal labor`,
         
         c_2_hh_size_change = `c_2  Since the beginning of the coronavirus outbreak, has there been a change in the number of people sleeping in your household?`,
         c_2_1_hhsize_more_workerreturned_pandemic = `c_2_1_1_Somebody working elsewhere returned home because of the coronavirus outbreak`,
         c_2_2_hhsize_more_workerreturned_planned = `c_2_1_2_Somebody working elsewhere returned home, as was already planned`,
         c_2_3_hhsize_more_studentreturned_pandemic = `c_2_1_3_Somebody studying elsewhere returned home because of the coronavirus outbreak`,
         c_2_4_hhsize_more_studentreturned_planned = `c_2_1_4_ Somebody studying elsewhere returned home, as was already planned`,
         c_2_5_hhsize_more_other = `c_2_1_other specify`,
         c_2_1_hhsize_less_workerleft_pandemic = `c_2_2_1_Somebody that was living at home left to go work elsewhere, due to the coronavirus pandemic`,
         c_2_2_hhsize_less_workerleft_planned = `c_2_2_2_Somebody that was living at home left to go work elsewhere, as was already planned`,
         c_2_3_hhsize_less_studentleft_pandemic = `c_2_2_3_ Somebody that was living at home left to go study elsewhere, due to the coronavirus pandemic`,
         c_2_4_hhsize_less_studentleft_planned = `c_2_2_4_Somebody that was living at home left to go study elsewhere, as was already planned`,
         c_2_5_hhsize_less_other = `c_2_2_other specify`,
         
         c_3_lockdown_ago_weeks = `c_3 How long ago did your block experience orders to restrict time outdoors due to covid-19? _____ [weeks]`,
         c_4_change_lockdown_since = `c_4  Has there been a change in orders to restrict time outdoors in your area since then?`,
         
         d_0_1_primary_lighting_fourdays = `d_0_1  In the last four days, what has been the primary source of lighting in your household?`,
         d_0_1_primary_lighting_other = `d_0_1_other specify`,
         
         d_0_all_lighting_grid = `d_0_1   Grid electricity`,
         d_0_all_lighting_kerosene = `d_0_2  Kerosene lamp/lantern`,
         d_0_all_lighting_microgrid = `d_0_3  Micro-grid`,
         d_0_all_lighting_solar = `d_0_4   Solar home system or solar lantern`,
         d_0_all_lighting_other = `d_0_other specify`,
         
         d_0_2_has_kerosene = `d_0_2  Does your household have kerosene lamps for lighting?`,
         d_0_2_1_1_not_used_kerosene_nofuel = `d_0_2_1_1  No kerosene fuel in the household`,
         d_0_2_1_2_not_used_kerosene_conservingfuel = `d_0_2_1_2  Running low on kerosene fuel in the household and saving it`,
         d_0_2_1_3_not_used_kerosene_unablebuy = `d_0_2_1_3   Unable to purchase kerosene from ration shop or usual place of purchase`,
         d_0_2_1_4_not_used_kerosene_notgoodlight = `d_0_2_1_4  Kerosene is not a good source of light`,
         d_0_2_1_5_not_used_kerosene_unsafe = `d_0_2_1_5  Kerosene is not safe`,
         d_0_2_1_6_not_used_kerosene_hasbetter = `d_0_2_1_6  No need because we have better forms of lighting`,
         d_0_2_1_7_not_used_kerosene_broken = `d_0_2_1_7   Kerosene lamps are broken`,
         d_0_2_1_8_not_used_kerosene_other = `d_0_2_1_other specify`,
         
         d_0_3_1_kerosene_use_compare = `d_0_3_1  Thinking back to before the lockdown, are you now using kerosene for lighting more, the same, or less than before? [Note to surveyor: Do not read options unless clarification needed]`,
         d_0_3_2_kerosene_use_compare_hours = `d_0_3_2  Thinking back to during the lockdown, in comparison to before lockdown, did you use kerosene for lighting for the same number of hours, for more hours, or for fewer hours? [do not read options unless clarification needed]`,
         d_0_3_4_kerosene_use_hours = `d_0_3_4  n the last four days, in a typical day, how many hours a day did you have at least one kerosene lamp on for lighting? [NUMBER OF HOURS DURING WHICH AT LEAST ONE LAMP IS ON] ______________ [HOURS/DAY]`,
         
         d_2_primary_cook_fuel = `d_2  In the last four days, what has been your primary cooking fuel?`,
         d_2_primary_cook_fuel_other = `d_2_other specify`,
         
         d_1_1_firewood = `d_1_1  Firewood and chips`,
         d_1_2_any_cook_fuel_agresidue = `d_1_2  Agricultural or crop residue`,
         d_1_3_any_cook_fuel_dung = `d_1_3  Animal waste / dung cakes`,
         d_1_4_any_cook_fuel_charcoal = `d_1_4  Charcoal`,
         d_1_5_any_cook_fuel_coal = `d_1_5  Coal`,
         d_1_6_any_cook_fuel_kerosene = `d_1_6  Kerosene / paraffin`,
         d_1_7_any_cook_fuel_alcohol = `d_1_7   Alcohol / ethanol`,
         d_1_8_any_cook_fuel_gasoline = `d_1_8  Gasoline / diesel (not in generator)`,
         d_1_9_any_cook_fuel_lpg = `d_1_9  Liquefied petroleum gas (LPG)`,
         d_1_10_any_cook_fuel_biogas = `d_1_10  Bio-gas`,
         d_1_11_any_cook_fuel_electricity = `d_1_11   Electricity`,
         d_1_12_any_cook_fuel_other = `d_1_other specify`,
         
         d_3_has_lpg = `d_3  Does your household have an LPG connection?`,
         d_3_1_1_not_used_lpg_nofuel =`d_3_1_1  No LPG fuel in the household`,
         d_3_1_2_not_used_lpg_conservingfuel =`d_3_1_2  Running low on LPG fuel in the household and saving it`,
         d_3_1_3_not_used_lpg_notcookusualdishes =`d_3_1_3  The households has not cooked the usual dishes that the LPG stove is used for`,
         d_3_1_4_not_used_lpg_otherfuels =`d_3_1_4  The household has lots of other fuels that we are using instead`,
         d_3_1_5_not_used_lpg_notlikenow =`d_3_1_5   We do not like to use the LPG stove these days`,
         d_3_1_6_not_used_lpg_fearful =`d_3_1_6  Fear of using the LPG stove`,
         d_3_1_7_not_used_lpg_usualcookisnotcook =`d_3_1_7   The person that normally cooks using LPG has not been cooking`,
         d_3_1_8_not_used_lpg_broken = `d_3_1_8  The LPG stove is broken and cannot be used`,
         d_3_1_9_not_used_lpg_other = `d_3_1_other specify`,
         
         d_4_lpg_via_pmuy = `d_4  Did you receive the LPG connection under Pradhan Mantri Ujjwala Yojana (PMUY)?`,
         d_5_multiple_cylinders = `d_5  Do you have more than one gas cylinder in your household?`,
         d_5_1_multiple_cylinders_sizes = `d_5_1  What size are the LPG cylinders you currently have?`,
         d_5_2_one_cylinder_size = `d_5_2_What size is the LPG cylinder you currently have?`,
         d_5_3_singleordouble_connection = `d_5_3_Do you have a single or double bottle connection from your LPG provider (LPG Agency)?`,
         d_5_4_second_cylinder_source = `d_5_4_If single bottle connection, so from whom did you take the second LPG cylinder?`,
         
         d_6_fourdays_typical_number_meals = `d_6  In the last four days, during a typical day, about how many meals have been cooked in your house? (Note to interviewer: this question seeks to estimate the average number of meals cooked per day -- not a sum over the past four days) _________ [# meals per day]`,
         d_7_fourdays_hours_cook = `d_7  In the last four days, during a typical day, how much time is spent cooking? _________ [# hours per day]All meals combined — total number of hours cooking / stove on in the entire day`,
         d_8_1_cook_hours_compare_inlockdown = `d_8_1  Thinking back to before the lockdown, are you now cooking in total for more hours, for the same number of hours, or for fewer hours as compared to before?`,
         d_8_2_cook_hours_compare_recalllockdown = `d_8_2  During the lockdown, in comparison with before the lockdown, did you cook for more hours, for the same number of hours, or for fewer hours overall? [do not read options unless clarification needed]`,
         
         d_9_lpg_use_compare = `d_9  Compared to before lockdown, how are you using LPG? If something has changed, please tell us. [READ OPTIONS]`,
         d_10_pollutingfuel_use_compare = `d_10  Thinking back to before the lockdown, how would you describe your use of the traditional fuels like firewood, coal, dung, agricultural residues, and kerosene now? [READ OPTIONS]`,
         
         e_1_1_refill_lpg_inlockdown = `e_1_1  Since the lockdown began, have you refilled your LPG cylinder?`,
         e_1_2_refill_lpg_recalllockdown = `e_1_2 During the period of the lockdown, did you refill your LPG cylinder?`,
         
         e_2_refill_lpg_wksago = `e_2  How many weeks ago did you last refill your large LPG cylinder? ______ [# weeks]`,
         e_3_refill_source = `e_3  Where did you get that refill from?`,
         e_3_refill_source_other = `e_3_other specify`,
         e_4_1_refill_differences_nodelivery = `e_4_1 No delivery as compared to usual delivery`,
         e_4_2_refill_differences_deliverynow = `e_4_2  Delivery as compared to not usually getting delivery`,
         e_4_3_refill_differences_longerwait = `e_4_3   Longer wait as compared to usual at distributor shop`,
         e_4_4_refill_differences_shorterwait = `e_4_4  Shorter wait as compared to usual at distributor shop`,
         e_4_5_refill_differences_pickupfurther = `e_4_5  Village pick-up point was further away than usual`,
         e_4_6_refill_differences_pickupcloser = `e_4_6  Village pick-up point was closer than usual`,
         e_4_7_refill_differences_none = `e_4_7_There were no differences`,
         e_4_8_refill_differences_other = `e_4_other specify`,
         
         e_5_subsidy_time_compare = `e_5  Thinking back to before the lockdown, does it take less time, more time, or the same amount of time to receive the subsidy amount in your bank account?`,
         e_6_lpgrefill_cost = `e_6  How much did you pay at the time of purchase for your last LPG cylinder? ______ [INR]`,
         e_7_1_nolpg_refill_didnotrunout = `e_7_1  Did not run out of gas`,
         e_7_2_nolpg_refill_rationed = `e_7_2  Rationed gas so I did not run out`,
         e_7_3_nolpg_refill_nomoney = `e_7_3   Did not have money available`,
         e_7_4_nolpg_refill_didnotwanttoleave = `e_7_4  Did not want to leave household to get refill`,
         e_7_5_nolpg_refill_deliveryunavailable = `e_7_5  Normal gas delivery not available`,
         e_7_6_nolpg_refill_couldnotleave = `e_7_6 Was not allowed to leave household to get refill`,
         e_7_7_nolpg_refill_other = `e_7_other specify`,
         
         e_8_refill_next_wks = `e_8  When do you expect to next refill an LPG cylinder? ______ [# weeks]`,
         
         f_1_firewood_compare_collect_freq_inlockdown = `f_1 As compared to before the lockdown, has your household been collecting firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_2_firewood_compare_collect_amt_inlockdown = `f_2 As compared to before the lockdown, has your household collected more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         # f_3_firewood_compare_reserve_amt_inlockdown = `f_3 As compared to before the lockdown, does the household now have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically? [Note for surveyor: This question refers to the amount/volume/weight of fuel being stored in the household. Households often have some amount of fuel being stored that they then are able to use for cooking at any given point. Here, we ask if they have approximately the same, more, or less fuel stored in the household as compared to before.]`,
         f_4_firewood_compare_collect_difficulty_inlockdown = `f_4  As compared to before the lockdown, does the household now have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_5_firewood_compare_collect_freq_recalllockdown = `f_5  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect firewood, twigs, agricultural residues, or dung cakes more, the same, or less frequently than before?`,
         f_6_firewood_compare_collect_amt_recalllockdown = `f_6  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect more, the same, or less firewood, twigs, agricultural residues, or dung cakes in a typical trip than before?`,
         f_7_firewood_compare_reserve_amt_recalllockdown = `f_7  Thinking back to during the lockdown, in comparison with before the lockdown, did your household have more, the same, or less firewood, twigs, agricultural residues, or dung cakes in the household typically?`,
         f_8_firewood_compare_collect_amt_recalllockdown = `f_8  Thinking back to during the lockdown, as compared to non-lockdown times, did your household have a more difficult, an easier, or about the same difficulty acquiring firewood, twigs, agricultural residues, or dung cakes?`,
         f_9_firewood_collect_last_days = `f_9  When was the last time a household member collected firewood, twigs, agricultural residues, or dung cakes? ______ [days ago]`,
         f_10_firewood_collect_next_days = `f_10  When do you expect that a household member will next go for collecting firewood, twigs, agricultural residues, or dung cakes? ______ [days from now]`,
         
         f_11_coal_compare_collect_freq_inlockdown = `f_11  As compared to before the lockdown, has your household been collecting coal more, the same, or less frequently than before?`,
         f_12_coal_compare_collect_amt_inlockdown = `f_12  As compared to before the lockdown, has your household been collecting coal more, the same, or less in a typical trip than before?`,
         f_13_coal_collect_location_inlockdown = `f_13  Where have you gone to get coal during lockdown?`,
         f_13_1_1_nocoal_havefuel = `f_13_1_1  I have not run out of coal`,
         f_13_1_2_nocoal_notusing = `f_13_1_2  I have not been using coal for cooking during lockdown`,
         f_13_1_3_nocoal_nomoney = `f_13_1_3  Did not have money available`,
         f_13_1_4_nocoal_didnotwanttoleave = `f_13_1_4  Did not want to leave household to get coal`,
         f_13_1_5_nocoal_normalspotunavailable = `f_13_1_5   Normal coal buying location not available`,
         f_13_1_6_nocoal_cantleave = `f_13_1_6  Was not allowed to leave household to get coal`,
         f_13_1_7_nocoal_other = `f_13_1_other specify`,
         
         f_14_coal_compare_collect_freq_recalllockdown = `f_14  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect coal more, the same, or less frequently than before?`,
         f_15_coal_compare_collect_amt_recalllockdown = `f_15  Thinking back to during the lockdown, in comparison with before the lockdown, did your household collect the same, or less in a typical trip than before?`,
         f_16_coal_compare_collect_location_recalllockdown = `f_16  Thinking back to during the lockdown, where did you go to get coal?`,
         
         g_1_lpg_refill_cost_compare_inlockdown = `g_1_1  Since the lockdown has begun, how does the price of an LPG cylinder refill compare to before?`,
         g_1_lpg_refill_cost_compare_reaclllockdown = `g_1_2   Thinking back to during the lockdown, in comparison with before the lockdown, how did the price of an LPG cylinder refill compare to before?`,
         g_2_lpg_refill_difficulty_inlockdown = `g_2  Since the lockdown began, is it now easier, more difficult, or the same difficulty of acquiring an LPG cylinder refill?`,
         g_3_1_like_using_lpg_more = `g_3  Do you agree or disagree with the following statement: Since the lockdown has begun, we like to cook with gas more than before.`,
         g_3_1_1_like_using_lpg_more_valuefastcooking = `g_3_1_1  We value faster cooking with LPG more now during lockdown`,
         g_3_1_2_like_using_lpg_more_cheapernow = `g_3_1_2   LPG is cheaper now`,
         g_3_1_3_like_using_lpg_more_accessiblenow = `g_3_1_3   LPG is more accessible now`,
         g_3_1_4_like_using_lpg_more_threecylpolicy = `g_3_1_4   Three free cylinder policy`,
         g_3_1_5_like_using_lpg_more_lessbiomassnow= `g_3_1_5  Household has less biomass now`,
         g_3_1_6_like_using_lpg_more_biomassacquireharder = `g_3_1_6   Household can acquire biomass less easily now`,
         g_3_1_7_like_using_lpg_more_tastepreferenceforlpg = `g_3_1_7  Household preferences favor the taste of food cooked with LPG`,
         g_3_1_8_like_using_lpg_more_tastepreferenceawayfirewood = `g_3_1_8  Household preferences shifting away from the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_1_9_like_using_lpg_more_prefercooklpg = `g_3_1_9  Household preferences favor the experience of cooking with LPG`,
         g_3_1_10_like_using_lpg_more_awaycookfirewood = `g_3_1_10  Household preferences shifting away the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_1_11_like_using_lpg_more_other = `g_3_1_other specify`,
         
         g_3_2_1_like_using_lpg_less_morecostly = `g_3_2_1   LPG is more expensive now`,
         g_3_2_2_like_using_lpg_less_lessaccessible = `g_3_2_2   LPG is less accessible now`,
         g_3_2_3_like_using_lpg_less_morebiomassnow = `g_3_2_3  Household has more biomass now`,
         g_3_2_4_like_using_lpg_less_tastepreferenceforfirewood = `g_3_2_4  Household preferences favor the taste of food cooked over firewood, twigs, or agricultural residues`,
         g_3_2_5_like_using_lpg_less_tastepreferenceawaylpg = `g_3_2_5  Household does not prefer the taste of food cooked with LPG`,
         g_3_2_6_like_using_lpg_less_prefercookfirewood = `g_3_2_6 Household preferences favor the experience of cooking with firewood, twigs, or agricultural residues`,
         g_3_2_7_like_using_lpg_less_awaycooklpg = `g_3_2_7  Household does not prefer the experience of cooking with LPG`,
         g_3_2_8_like_using_lpg_less_other = `g_3_2_other specify`,
         
         h_1_threecylinder_aware = `h_1   As of April 1, 2020, the Government of India has made three free LPG cylinder refills available to Ujjwala beneficiaries. Prior to our conversation, were you or anybody in this household aware of this policy?`,
         h_2_threecylinder_aware_how = `h_2   How did you or anybody in the household become aware of this program/policy?`,
         h_2_threecylinder_aware_how_other = `h_2_other specify`,
         h_3_lpg_refill_subsidy_deposited = `h_3  Have you received an LPG refill subsidy deposited into your bank account?`,
         h_4_obtained_free_cylinder = `h_4  Have you obtained or received any of these three free cylinders?`,
         h_4_1_obtained_free_cylinder_number = `h_4_1  How many such free refills have you received? ______ [# refills; MAXIMUM NUMERIC VALUE OF 5]`,
         h_4_2_free_cylinder_process_convenience = `h_4_2  Did you find the process as convenient as acquiring a typical refill?`,
         h_4_2_1_process_difficult_fullpriceatsale = `h_4_2_1_1   Having to pay the full price at the time of sale is difficult`,
         h_4_2_2_process_difficult_longgetsubsidy = `h_4_2_1_2   It took longer to receive the subsidy/stimulus in the bank account`,
         h_4_2_2_process_difficult_moredifficultrefill = `h_4_2_1_3  It was more difficult to get to where I refilled the cylinder as compared to before due to travel restrictions`,
         h_4_2_2_process_difficult_policyconfusionatsale = `h_4_2_1_4  There was confusion about the policy at the point of sale`,
         h_4_2_2_process_difficult_other = `h_4_2_1_other specify`,
         h_5_threecylinder_use_future = `h_5   Do you plan to take advantage of the program in the future?`,
         h_6_threecylinder_use_future = `h_6   Do you plan to take advantage of the program in the future?`,
         
         i_1_covid_threatlevel = `i_1  What level of threat do you think COVID-19 poses to you or your family?`,
         i_2_covid_followguidelines = `i_2  In general, to what extent are people in your village following government guidelines about physical distancing and lockdown?`,
         i_3_covid_firewood_increaserisk = `i_3   Do you agree or disagree with the following statement: Cooking with firewood increases risk of COVID-related serious illness or death?`,
         i_4_1_covid_lpg_reducerisk_choice = `i_4_1 If medical research finds that LPG use reduces risk of COVID related serious illness, what would best describe your situation regarding LPG use and other fuels as applicable in the future for household needs?`,
         i_4_1_covid_firewood_increaserisk_choice = `i_4_2 Suppose that medical experts find that using LPG more, and the Chula less, reduces risk of getting very sick from COVID. What would best describe your future plans for acquiring and then using LPG?`,
         
  ) %>% 
  na_if(-99) %>% 
  mutate(date_interview = ymd(convertToDate(date_interview)),
         start_time_interview = ymd_hms(convertToDateTime(start_time_interview)),
         end_time_interview = ymd_hms(convertToDateTime(end_time_interview)))

colnames(jcovid6_1)[152] <- "f_3_firewood_compare_reserve_amt_inlockdown" 

## 3. Make Data Maid Report ------

# automatically generates a PDF report (takes a few minutes)

dataMaid::makeDataReport(jcovid1_1, replace = T,
                         file = "~/Dropbox/Jharkhand-COVID19/Code/DataSummaryDocuments/dataMaid-jcovid1.Rmd")
dataMaid::makeDataReport(jcovid2_1, replace = T,
                         file = "~/Dropbox/Jharkhand-COVID19/Code/DataSummaryDocuments/dataMaid-jcovid2.Rmd")
dataMaid::makeDataReport(jcovid3_3, replace = T,
                         file = "~/Dropbox/Jharkhand-COVID19/Code/DataSummaryDocuments/dataMaid-jcovid3.Rmd")
dataMaid::makeDataReport(jcovid4_1, replace = T,
                         file = "~/Dropbox/Jharkhand-COVID19/Code/DataSummaryDocuments/dataMaid-jcovid4.Rmd")
dataMaid::makeDataReport(jcovid5_1, replace = T,
                         file = "~/Dropbox/Jharkhand-COVID19/Code/DataSummaryDocuments/dataMaid-jcovid5.Rmd")
dataMaid::makeDataReport(jcovid6_1, replace = T,
                         file = "~/Dropbox/Jharkhand-COVID19/Code/DataSummaryDocuments/dataMaid-jcovid6.Rmd")



# 4. Join repeated survey data ---------

jcovid_full <- jcovid1_1 %>% 
  mutate(round = "Round 1") %>% 
  bind_rows(jcovid2_1 %>%
              mutate(round = "Round 2")) %>%
  bind_rows(jcovid3_1 %>%
              mutate(round = "Round 3")) %>%
  bind_rows(jcovid4_1 %>%
              mutate(round = "Round 4")) %>%
  bind_rows(jcovid5_1 %>%
              mutate(round = "Round 5")) %>%
  bind_rows(jcovid6_1 %>%
              mutate(round = "Round 6")) 

# write_rds(jcovid_full, "~/Dropbox/Jharkhand-COVID19/Data/jcovid_full.rds")
# write_csv(jcovid_full, "~/Dropbox/Jharkhand-COVID19/Data/jcovid_full.csv")

# Check number of household IDs 
length(unique(jcovid_full$hhid)) # 882. Sounds reasonable. 

# 5. Join repeated survey data frame with baseline data  -----------

id_match <- jcovid_full$hhid %in% jbaseline$UniqueId 
table(id_match) # all are matched


# Denote all baseline columns with a "B_" prefix

jbaseline <- jbaseline %>%
  rename_all(funs(str_replace(.,"^", "B_"))) %>%
  rename(hhid = B_UniqueId)

jcovid_full_b <- jcovid_full %>%
  left_join(jbaseline, by="hhid")

# This is a full dataset, but the baseline column names aren't interpretable without the survey.
# So, relatively limited user friendliness, but all the data should be there. 

# write_rds(jcovid_full_b, "~/Dropbox/Jharkhand-COVID19/Data/jcovid_full_b.rds")
# write_csv(jcovid_full_b, "~/Dropbox/Jharkhand-COVID19/Data/jcovid_full_b.csv")

# 5.1 Clean baseline data column names * mostly done, a little incomplete * ------

jcovid_full_b_1 <- jcovid_full_b %>% 
  rename(B_q_14_relation_to_HH = B_q_14,
         B_q_16_age = B_q_16,
         B_q_17_gender = B_q_17,
         B_q_19_literate = B_q_19,
         B_q_19_speakHindi = B_q_19_1,
         B_q_19_writeHindi = B_q_19_2,
         
         B_q_20_HH_education = B_q_20,
         B_q_21_religion = B_q_21,
         B_q_22_caste = B_q_22,
         B_q_23_adultmen = B_q_23,
         B_q_24_adultwomen = B_q_24,
         B_q_25_children = B_q_25,
         B_q_26_children_studying = B_q_26,
         B_q_27_voterID = B_q_27,
         B_q_28_rationcard = B_q_28,
         
         B_q_29_primary_incomesource = B_q_29,
         B_q_31_monthly_expenditures = B_q_31,
         B_q_32_rupees_saved = B_q_32,
         B_q_33_woman_anyincome = B_q_33,
         
         B_q_34_land = B_q_34_1,
         B_q_34_land_unit = B_q_34_2,
         B_q_35_cows = B_q_35_1,
         B_q_35_buffaloes = B_q_35_2,
         B_q_35_chicken = B_q_35_3,
         B_q_35_cow_calves = B_q_35_4,
         B_q_35_buffalo_calves = B_q_35_5,
         B_q_35_goats = B_q_35_6,
         B_q_35_otheranimal = B_q_35_7,
         
         B_q_37_decisionmaker = B_q_37,
         B_q_38_pucca = B_q_38,
         B_q_39_toilet = B_q_39,
         B_q_40_pipedwater = B_q_40,
         B_q_41_rooms = B_q_41,
         B_q_42_beds = B_q_42,
         B_q_43_tables = B_q_43,
         B_q_44_chairs = B_q_44,
         B_q_45_bicycles = B_q_45,
         B_q_46_motorcycles = B_q_46,
         B_q_47_pressurecookers = B_q_47,
         B_q_48_34wheel_ag_equipment = B_q_48,
         B_q_49_fishingboat = B_q_49,
         B_q_50_govtemployee = B_q_50,
         B_q_51_taxpayer = B_q_51,
         
         B_q_57_primary_lighting = B_q_57,
         B_q_58_primary_lighting_meetsneeds = B_q_58_1,
         B_q_58_primary_lighting_isexpensive = B_q_58_2,
         B_q_58_primary_lighting_issafe = B_q_58_3,
         B_q_58_primary_lighting_isreliable = B_q_58_4,
         B_q_59_primary_lighting_satisfaction = B_q_59,
         
         B_q_60_grid_electricity = B_q_60,
         B_q_60_grid_electricity_years = B_q_60_1,
         B_q_60_grid_electricity_saubhagya = B_q_60_2,
         B_q_60_grid_electricity_cnxn_fee = B_q_60_3,
         B_q_60_grid_electricity_fixed_variable_fee = B_q_60_4,
         B_q_60_grid_electricity_monthly_fee = B_q_60_5_1,
         B_q_60_grid_electricity_monthly_repairs = B_q_60_5_2,
         B_q_60_grid_electricity_monthly_informalpayment = B_q_60_5_3,
         B_q_60_grid_electricity_monthly_paynongrid = B_q_60_5_4,
         
         B_q_61_microgrid_electricity = B_q_61,
         B_q_61_microgrid_electricity_source = B_q_61_1,
         B_q_61_microgrid_electricity_monthly_fee = B_q_61_2,
         
         B_q_62_solar_system = B_q_62,
         B_q_62_solar_system_hours = B_q_62_1,
         B_q_62_solar_system_lights = B_q_62_2,
         
         B_q_63_solar_lantern = B_q_63,
         B_q_63_solar_lantern_lights = B_q_63_1,
         B_q_63_solar_lantern_hours = B_q_63_2,
         
         B_q_64_kerosene_lighting = B_q_64,
         B_q_64_kerosene_wicklamp_number = B_q_64_1,
         B_q_64_kerosene_lantern_number = B_q_64_2,
         B_q_64_kerosene_lighting_hours = B_q_64_3,
         B_q_64_kerosene_lighting_PDSliters_month = B_q_64_4,
         B_q_64_kerosene_lighting_PDSliters_price = B_q_64_5,
         B_q_64_kerosene_lighting_marketliters_month = B_q_64_6,
         B_q_64_kerosene_lighting_marketliters_price = B_q_64_7,
         B_q_64_kerosene_lighting_health_effect = B_q_64_8,
         
         B_q_72_mobile_phone = B_q_72,
         
         B_q_73_electrification = B_q_73,
         B_q_74_electrification_hrs_available = B_q_74,
         
         B_q_80_electrification_satisfied = B_q_80,
         B_q_80_electrification_unsatisfied_expensive = B_q_80_1_1,
         B_q_80_electrification_unsatisfied_unavailable = B_q_80_1_2,
         B_q_80_electrification_unsatisfied_poorquality = B_q_80_1_3,
         B_q_80_electrification_unsatisfied_poormaintenance = B_q_80_1_4,
         
         B_q_81_grid_electricity_available = B_q_81, 
         B_q_81_grid_electricity_whynot_expensive = B_q_81_1, 
         B_q_81_grid_electricity_whynot_unavailable = B_q_81_2, 
         B_q_81_grid_electricity_whynot_unreliable = B_q_81_3, 
         B_q_81_grid_electricity_whynot_dk_how = B_q_81_4, 
         B_q_82_ever_grid_electricity = B_q_82,
         
         B_q_84_primary_cookfuel = B_q_84,
         B_q_85_cook_meals_daily = B_q_85,
         B_q_86_cook_hrs_daily = B_q_86,
         
         B_q_87_has_lpg = B_q_87,
         B_q_87_lpg_years = B_q_87_1,
         B_q_87_lpg_pmuy = B_q_87_2,
         B_q_87_lpg_connection = B_q_87_3,
         
         B_q_87_lpg_roti = B_q_87_4_1,
         B_q_87_lpg_veg_lentil = B_q_87_4_2,
         B_q_87_lpg_rice = B_q_87_4_3,
         B_q_87_lpg_teasnacks = B_q_87_4_4,
         B_q_87_lpg_milkboil = B_q_87_4_5,
         B_q_87_lpg_waterboil = B_q_87_4_6,
         B_q_87_lpg_nonveg = B_q_87_4_7,
         
         B_q_87_lpg_allneeds = B_q_87_5,
         B_q_87_lpg_allneeds_no_expensive = B_q_87_5_1_1,
         B_q_87_lpg_allneeds_no_freebiomassavail = B_q_87_5_1_2,
         B_q_87_lpg_allneeds_no_preferchulhasome= B_q_87_5_1_3,
         B_q_87_lpg_allneeds_no_dontlikelpgfood = B_q_87_5_1_4,
         B_q_87_lpg_allneeds_no_lpgavailabilityconstraint = B_q_87_5_1_5,
         
         B_q_87_large_lpg_cyls = B_q_87_7,
         B_q_87_large_lpg_cyls_cost_dist = B_q_87_12,
         B_q_87_large_lpg_cyls_cost_market = B_q_87_14,
         B_q_87_small_lpg_cyls = B_q_87_9,
         B_q_87_small_lpg_cyls_cost_dist = B_q_87_13,
         B_q_87_small_lpg_cyls_cost_market = B_q_87_15,
         B_q_87_lpg_doorstep_deliv = B_q_87_16,
         B_q_87_lpg_oneway = B_q_87_16_1,
         
         B_q_87_lpg_satisfaction = B_q_87_17,
         B_q_87_lpg_unsatisfied_expensive = B_q_87_17_1,
         B_q_87_lpg_unsatisfied_refillpooravail = B_q_87_17_1,
         B_q_87_lpg_unsatisfied_refilltoofar = B_q_87_17_1,
         B_q_87_lpg_unsatisfied_poormaintenance = B_q_87_17_1,
         
         B_q_87_lpg_refill_order_receive_gap = B_q_87_18,
         B_q_87_lpg_refill_subsidy_who_acct = B_q_87_19,
         B_q_87_lpg_refill_who_orders = B_q_87_20,
         B_q_87_lpg_refill_who_gets = B_q_87_21,
         
         B_q_88_no_lpg_why_not_avail_too_far = B_q_88_1,
         B_q_88_no_lpg_why_cnxn_too_expensive = B_q_88_2,
         B_q_88_no_lpg_why_lpgrefill_too_expensive = B_q_88_3,
         B_q_88_no_lpg_why_dk_how = B_q_88_4,
         
         B_q_89_no_lpg_wants = B_q_89,
         B_q_89_wants_lpg_wtp_cnxn = B_q_89_1,
         B_q_89_wants_lpg_wtp_refills = B_q_89_2,
         
         B_q_90_use_firewood_chips = B_q_90,
         B_q_90_collect_firewood_forest = B_q_90_1_1,
         B_q_90_collect_firewood_roadside = B_q_90_1_2,
         B_q_90_collect_firewood_farm = B_q_90_1_3,
         
         B_q_90_firewood_kg_week = B_q_90_2,
         B_q_90_firewood_kg_week_collected = B_q_90_3,
         B_q_90_firewood_kg_week_bought_market = B_q_90_4,
         B_q_90_firewood_kg_cost = B_q_90_5,
         B_q_90_firewood_collect_freq = B_q_90_6,
         B_q_90_firewood_collect_hrs_trip = B_q_90_6_1,
         B_q_90_firewood_collect_km_trip = B_q_90_6_2_1,
         B_q_90_firewood_buy_km_trip = B_q_90_6_2_2,
         
         B_q_91_use_dung = B_q_91,
         
         B_q_92_use_ag_residue = B_q_92,
         B_q_93_use_coal = B_q_93,
         
         B_q_96_kitchen = B_q_96,
         B_q_97_primary_cookstove_satisfaction = B_q_97,
   
  ) 

